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
|