Change text in a Cell

S

seanA

How do I search a whole column, and If the Cell Contains the partia
string "STILE". I would like to changewhole text in the cell to b
"DIFFERENT".

Thanks for your Help
 
K

kkknie

1. Select the entire column you want to search.
2. From the Edit MenuBar, select Replace (or hit Ctrl-H)
3. In the Find What text box put *STILE*
4. In the Replace With box put DIFFERENT

The asterisks at the front and back allow you to replace the entir
word.
 
Top