Thread: counting the number of characters in a cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F[_2_] Dave F[_2_] is offline
external usenet poster
  
Posts: 187
Default counting the number of characters in a cell
On Dec 18, 4:11 pm, wrote:
Is there a formula that will tell me how many character are in a
cell. For example

cell 1 Happy it will return 5
cell 2 Happy Birthday it will return 14

I need to include spaces in the count.

Thanks in advance for your help.

=LEN(A1) etc.
Reply With QuoteReply With Quote