How can I see what cell A1 contains?
It appears empty but =ISBLANK(A1) returns "FALSE"

A simple method:
Copy A1 to notepad.

To work around this issue, clear the zero-length string from the cell. To do this, select the cell, click Edit, and then click Clear All.

In addition, you can also check whether a cell contains a zero-length string by using the LEN function. For example, if the cell you are checking is A1, the formula will be =OR(Len(A1)=0, Isblank(A1)).

Let me know if this gave you some insights.

Regards,
Jerry

Hello! Maybe you can check if there is a space in the cell. It will really return FALSE if there is even a space there. Hope this helps!

By the way, you can also check here for more excel help.