How do I replace all occurances of a word (or words) on a sheet? 2

[jhetfield]

Is there a way to replace all ocurrances of a word (or words), on an Excel sheet,with another word (or words)?

Thanks, Jason

 

[bluedragon2]

on the menu bar:

do edit/replace

type the word you want to replace and the word you want to replace it with, then hit replace all

 

[Shelbyville]

Hopefully this is obvious to you, but it's a good idea to make a copy of the file before you starting replacing. Sometimes what find/replace can result in something not quite right. Being able to start over is much better than having to fix what's broken.
Just a thought.