PDA

View Full Version : Sleeper: Non-Printing Characters


mdmackillop
08-30-2005, 10:43 AM
The attached data was exported by a Dos Sage programme to a CSV file, then modified and saved as an XLS file. There is something in B9 which is returning an error. Can anyone identify it? :banghead:
Bob Phillips
08-30-2005, 11:28 AM
It's a simple "" isn't it? IsEmpty returns false, len returns o, IsNull returns false, it can only be "".
Jacob Hilderbrand
08-30-2005, 11:37 AM
It is "" and if you evaluate the formula you get ""*0.
TonyJollans
08-30-2005, 12:56 PM
Interestingly, perhaps, when I opened the workbook in 2003 I could see nothing wrong - and ISBLANK(B9) returned TRUE. It was only when I used 2000 that I saw the problem.
mdmackillop
08-30-2005, 01:01 PM
Code(B9) also returns a #Value error.
Jacob Hilderbrand
08-30-2005, 01:12 PM
I can duplicate the error by putting ="" in a cell, then copy/pastespecial values. Perhaps there was a formula that returned a ""?