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?