How do I find out if I have invisible characters?

"Peo Sjoblom" wrote:

If you have a formula in CD15 then it is not blank and Excel will return
FALSE

Try this instead

=IF(Sheet1!CD15="","",Sheet1!BU6)


If you don't have a formula in CD15 then you must have invisible characters
in the cell
--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"Bill R" wrote in message
...
I am using ISBLANK in a formula and it keeps returning "false" when it
should
be returning "true", because (SHEET1!CD15) is blank. What could be causing
this problem?

This is my formula: =IF(ISBLANK(Sheet1!CD15),"",Sheet1!BU6)

Thanks, Bill