| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change an empty cell back to a blank cell ...
I have a spreadsheet with a large expanse of empty cells. However,
because I used a vlookup command and copied out the results as their values, then returned the results to the same locations, cells that APPEAR empty do NOT register as blank. Any sugesstions how I can return the empty cells to blank status without checking each one by hand? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to auto count data in an empty cell to be 0. Blank cell=0 | Excel Discussion (Misc queries) | |||
| CONVERTING AN EMPTY TEXT BACK TO BEING BLANK | Excel Programming | |||
| How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
| Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) | |||
| Find a non-blank cell and bring back text a in same row | Excel Worksheet Functions | |||
![LarryLev[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
