count in cell

J

Joe

Does anybody know how I can count the number of characters in a cell, I know

how to use the 'count' and 'counta' function to count the number of cells

used but not in a cell.

Thanks
 
O

Otto Moehrbach

Joe
Be aware that a space is a character to Excel. IOW, if you put "Hello"
in a cell (without the quotes), the Len formula will show 5. If you put a
space character before it or after it or within it, the Len formula will
show 6. HTH Otto
 
Top