Home > IT Answers > Microsoft Windows > find and replace in excel
Lrhehn
5 pts.
 find and replace in excel
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?

Software/Hardware used:
ASKED: February 23, 2012  2:50 PM
UPDATED: March 1, 2012  12:43 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  March 1, 2012  12:41 pm  by  shivasanjay   1,055 pts.
All Answer Wiki Contributors:  shivasanjay   1,055 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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 !

Subhendu Sen
 22,035 pts.
 

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.

shivasanjay
 1,055 pts.