Change text in a Cell
 

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

--
Message posted from http://www.ExcelForum.com

Change text in a Cell
 

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.



--
Message posted from http://www.ExcelForum.com