Thread: counting the number of characters in a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] bridgetv@gmail.com is offline
external usenet poster
  
Posts: 6
Default counting the number of characters in a cell
On Dec 18, 4:15 pm, Dave F wrote:
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.

Thanks it worked!
Reply With QuoteReply With Quote