| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill in Blank Cells (and cells that look blank that are not)
I imported some data and had several extra spaces in each cell.
I used the trim command in a new sheet, and then copy and paste values for the data that I want to work with. I then use the vlookup to reference this data on another sheet. I then try to subtract the two numbers, and if the cell is "blank", I get the #VALUE! error. If I F5/Special/Blank, these cells are not highlighted for input (as if they are not blank). Is there any way that I can get these cells to contain a 0(Zero), so that I can perform the calculations without error? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill blank cells with cells above data | Excel Worksheet Functions | |||
| Fill in blank cells | Excel Discussion (Misc queries) | |||
| automatically fill in blank cells?? | Excel Worksheet Functions | |||
| FILL IN BLANK CELLS | Excel Discussion (Misc queries) | |||
| Fill blank cells | Excel Discussion (Misc queries) | |||
Threaded Mode
