I have discovered that if I select the offending cell, click in the formula bar and then click on return the discrepancy disappears.

That doesn't make sense to me either.

I have also checked the LEN function which returns 0.