I am in the middle of a HUGE excel spreadsheet that has titles of names
of an item.
An Example is:

SS HOOP W/ DANGLING OPEN HEART EARRING

I am trying to Delete the SS from the entire spreadsheet, but when I do
a find - replace it deletes others words that have SS in it. Like
Crosses.

I also need to rename SS to Sterling Silver in another spreadsheet.

How can I do this?

I hope it doesnt require VBA

thanks.


--
melissa
------------------------------------------------------------------------
melissa's Profile: http://www.excelforum.com/member.php...o&userid=31791
View this thread: http://www.excelforum.com/showthread...hreadid=515194