| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a blank Cell
I'd like a simple equation. With a complication. The Equation is simply
"=A1". The complication is that if A1 is blank, I want a blank cell, not zero ("0"). You can test for a blank cell with ISBLANK, but if you say "If(isblank(A1),"",A1), you don't get a blank cell, you get a cell containing no visible characters. -- Charles |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy cell to another that is blank | Excel Programming | |||
| Need macro to check if cell is not blank & previous cell is blank, copy information from row above & paste | Excel Programming | |||
| Copy to first Blank cell in Colum C Non blank cells still exist be | Excel Programming | |||
| Copy data in one cell to blank cell immediately below, repeat | Excel Worksheet Functions | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
Threaded Mode
