find and replace in excel

5 pts.
Tags:
Microsoft Excel
microsoft excel functions
I want to use the find and replace feature under Edit. i want to find a word and replace that word in a difference format. For example, replace charcoal with [strong]charcoal [/strong](in red, bold format), but instead it replaces [strong]ALL the contents in the cell[/strong] with 'red, bold'. I am asking it just replace the word charcoal in red, bold. Thoughts?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Yes , this can be done , you have already found the menu and option.Juct click the “options” below the “Replace” label at right corner. Then give your proper format. you are ready with your customize find and replace.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Subhendu Sen
    I am not sure, if I understood correctly, if u don't want to replace all words (charcoal) at a time, then type the said word in under Search for and type the new word under Replace with.... now click Replace button instead Replace All. In this process if u don't want to replace the same word then click Find button and it ignore it and finds the next word. I am not sure, if it helps u !
    27,780 pointsBadges:
    report
  • shivasanjay
    Many times we ignore the available features of MS Excel. Because of igorance it happens that we donot use the system with efficiently. We need to search and discover the features which normally looks absent.
    2,425 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following