Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FIND&REPLACE
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
find and replace | Setting up and Configuration of Excel | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
Find & Replace Help | Excel Discussion (Misc queries) | |||
find replace cursor default to find box | Excel Discussion (Misc queries) |