Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How Do I find/replace a blank cell with a formula?
I am trying to repalce all blank cells with a formula but I cannot seem to
figure out how to enter the replace with my formula? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How Do I find/replace a blank cell with a formula?
I just did a test and this worked:
- Hi-light the range of cells you want to find/replace. - 'Edit'...'replace'...click on the replace tab. In the find window just leave it blank, in the replace with window enter your formula. Click the 'options' button and check off the match entire cell contents box. - Click the replace all button. "Alvin" wrote: I am trying to repalce all blank cells with a formula but I cannot seem to figure out how to enter the replace with my formula? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How Do I find/replace a blank cell with a formula?
See if this works for you:
Instead of Find/Replace.... Select the range containing the blank cells you want impacted <edit<goto Click the [special cells] button Check: Blanks Click the [OK] button That will select the blank cells in that range. Press the [F2] key to begin editing the active cell. Enter the formula, being mindful of the workings of relative references Then...Hold down the [ctrl] key and press [enter] That will put the formula in each blank Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Alvin" wrote: I am trying to repalce all blank cells with a formula but I cannot seem to figure out how to enter the replace with my formula? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
Excel VB-Copy formula down until adjacent cell (left) is blank? | Excel Discussion (Misc queries) | |||
blank cell turns to 0 | New Users to Excel | |||
How to stop excel from plotting a "blank" cell with formula as zer | Excel Discussion (Misc queries) |