is it empty or not?

[UALynn]

I have opened a text file into a workbook.
If I insert a formula in the workbook =len(B2) it returns a value of 0 for cells where I don't see any text.
However, in VBA when I do a len on the same cell I get a return of 252.

Debug.Print Len(.Range("B2"))

So I can't tell if the cell is empty using isempty because it thinks something is there.