Ignoring formula when checking blank cells

[Stanman]

Hi,
I have a formula that checks if the cell is blank and returns a value but its picking up the formula as a value, is there anyway to ignore it?

 

[Peter_SSs]

The Len returns 1

Then there is a character in there.
If you put this in an empty cell, what does it return?
=CODE(D3)