Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filling empty cells with a value
Hi
Is there a way of finding empty or blank cells and filling them with XXX or some text so I can find and replace XXX with YYY? Thanks Ian |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filling empty cells with a value
You could try
EditGotoSpecialBlanks Then type XXX and hit Ctrl-Enter not just Enter. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "Ian Richardson ACITP" wrote in message ... Hi Is there a way of finding empty or blank cells and filling them with XXX or some text so I can find and replace XXX with YYY? Thanks Ian |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filling empty cells with a value
Try something like this:
Select the range you want impacted <edit<replace Find what: (leave this blank) Replace with: XXX Click the [Replace All] button That should put "XXX" in each blank cell in the highlighted region. Does that help? *********** Regards, Ron XL2002, WinXP "Ian Richardson ACITP" wrote: Hi Is there a way of finding empty or blank cells and filling them with XXX or some text so I can find and replace XXX with YYY? Thanks Ian |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filling empty cells with a value
You can apply an autofilter and select Blanks from the pull-down menu.
In the first blank cell enter XXX then copy this down while the filter is still active. If you have blanks in many different columns, then select the topmost cell within the data area and Edit | GoTo and select Special followed by Current Region. Then Edit | GoTo | Special again and this time select Blanks. You can then type XXX and use CTRL-Enter to copy it into each blank cell. Hope this helps. Pete |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filling empty cells with a value
Thanks for the quick replies.
The find and replace does what I want. Easy if you think about it! Ian "Pete_UK" wrote: You can apply an autofilter and select Blanks from the pull-down menu. In the first blank cell enter XXX then copy this down while the filter is still active. If you have blanks in many different columns, then select the topmost cell within the data area and Edit | GoTo and select Special followed by Current Region. Then Edit | GoTo | Special again and this time select Blanks. You can then type XXX and use CTRL-Enter to copy it into each blank cell. Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying values but skipping empty cells | Excel Worksheet Functions | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Calculating slope, intercept, LOGEST with empty cells in data | Excel Worksheet Functions | |||
How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) | |||
Counting empty cells within a range of cells | New Users to Excel |