Hi Tempy,

I forgot to add:

And what do you see in the formula bar when you select X100.

---
Regards,
Norman



"Norman Jones" wrote in message
...
Hi Tempy,

Try hitting Ctl End (both keys) and (presumably) the cursor jumps to a
cell
in the last of the 'empty' five columns.
Assuming the cell is X100. In cell X101 enter the formula
=len (X100)
What do you now see in cell X101 - obviously, replace the cell references
with your own!