counting the number of characters in a cell

  • Thread starter Thread starter bridgetv
  • Start date Start date
B

bridgetv

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.
 
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.
Click to expand...

=LEN(A1) etc.
 
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.
Click to expand...


=LEN(cell_ref)


--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula/Function for Counting Characters in a cell 4
Counting the number of times a character occurs in a cell 1
Count the times a specific character appears in a cell 3
Adding the total # of characters in multiple cells 3
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
count - but exclude counting cells with a formula 4
Counting assistance 3
Counting numbers & characters in a cell 3

Back
Top