CSV file with 13space characters in blank cells

J

Jim May

In my office we've just received a recurring report
which has been modified (by someone. Previously
(a CSV file) the Data area (say A1:M30 ) had numbers
or blank cells representing 0 (zero) values.

Now, however the blank cells ARE NOT BLANK (although
they appear blank) all cells without numbers have 13
hard-space values in them, which is causing #VALUE!
problems;

I temporarily added an intermediate sheet with formula:
=IF(ISNUMBER(VALUE(MySheet!B2)),MySheet!B2,0)
to eliminate the #Value! problem; Is there a better way?
I'm sure there is, just not certain at this point in time.
Any input appreciated...
TIA,
 
D

Dave O

How about a Find and Replace? Click >Edit >Replace; enter thirteen
hard spaces in the FIND box and leave the REPLACE WITH box empty.

Sometimes these cells come across with a leading apostrophe- let us
know if yours does too.
 
J

Jim May

Dave:
Thanks; How could I forget 'ye ole' Find and replace...
Too Quickly resorted to a formula solution. I need to
say someting to our IS dept about how these $0.00 values
are getting converted to the 13 space characters. The leading
apostrophe is not there.
Tks again,,
Jim
 
Top