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

As with the blanks, Excel only replaces the current region.
Try this:
Select all blank cells you wish to replace with OK, or Find Sepcial Blanks
Create a custom a rare format. Format Cells Number Custom [Blue]0
Replace what: Format [Blue]0
Repalce with: Ok

"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