Thread: Character Count
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default Character Count

=LEN(A1)

will count spaces as well so if you want to disregard those use

=LEN(SUBSTITUTE(A1," ",""))


--

Regards,

Peo Sjoblom

"Hardip" wrote in message
...
Hi All

I am trying to count the number of characters in a cell i.e. all numbers,
letters and smybols.

Is there are worksheet function that can assist me?

Thanks in advance to all whom reply.

Regards, H