Thread: FIND&REPLACE
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tevuna Tevuna is offline
external usenet poster
 
Posts: 136
Default FIND&REPLACE

Make sure you've placed a check next to "Match entire cell contents" before
you replace the single C wiith Company

"mike" wrote:

I have to do the following in a selected group of cells, I wish to replace
ALL blank cells at one time with the word OK. When I do and edit & find, it
only replaces a few cells leaving many blank cells alone.

I have to replace all cells that have the single letter C in them witha word
company and ingnore cells that have the letter c inside a longer word like
car.
the edit & find statement locates all cells that have c in them either alone
or in a word.
Thanks to anyone who can help.
--
mike