Find Replace

[JimS]

I want to replace the word me with the letter m

However, throughout the spreadsheet there are other words like member
and mean. So if I do a find replace me with m it will also replace
the me in member with the letter m. it now says mmber.

Is there a way to avoid that? Perhaps putting me in quotes?

 

[Gord Dibben]

from you to me at same time, remember

edit>replace

what: <sp>me<sp>

with: <sp>m<sp>

returns from you to m at same time, remember


Gord Dibben MS Excel MVP

 

[Don Guillett]

If each word is in it's own cell then
options>replace ENTIRE cell

 

[JimS]

Both solutions are applicable. Thanks to you both. I learned
something.