Same as above:

This worked perfectly. It was so hard for me to troubleshoot this issue
since I couldn't find anything in the cell, yet it wasn't "empty".

I had imported from another application (not a website), but the character
was there, creating the error.

Thanks again for your help and the quick response!!!



"MartinW" wrote:

Hi,

It may be the non-breaking space (or hard space) problem.
One way to fix that is to use find and replace.
EditReplace
Find what: Alt+0160
Replace with: leave this blank
Click Replace All

To use unicode, hold down the Alt key, type the numbers
on the Number pad only, let go the Alt key.

To find out more about non-breaking spaces try a
google search.

HTH
Martin

"pcjjjr" wrote in message
...
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?