Empty cells from imported spreadsheet are not recognized as 0's

[Kyle18]

I imported a bunch of data from a DB and have encountered a Problem...

I have written a fairly simple formula: =IF(OR(B3>=60;C3>=60;D3>=60);TRUE;FALSE) which searches three cells and Returns a true if there is a number >=60 otherwise it should return a false.

In the spreadsheet with the DB data, blank cells are being read as nothing and returning a true. When I open a new workbook and try the formula, the empty cells are being read as a 0 and the formula works flawlessly. I have checked the cell formatting and they look identical to me.

Any suggestions??
Thanks!

[TMS]

Try using LEN to check the length of the data. Could be a non-printing character like CHAR(160)

[TMS]

And, if you can, post a sample workbook that demonstrates the problem. You can clear everything except the cells under discussion.

[Kyle18]

Here is the sample workbook.

[TMS]

Interestingly, if you use LEN to check the length of the data, it returns 0. However, if you use ISBLANK(...), it returns FALSE. Odd.

Must be something to do with the way the data is output.

Anyway, you can use this short macro to clean the data:

Please Login or Register  to view this content.

[Kyle18]

Thanks TMS!

[TMS]

You're welcome. Thanks for the rep.