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