count in cell

  • Thread starter Thread starter Joe
  • Start date Start date
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
 
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
 
Back
Top