counting the number of characters in a cell

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.
 
D

Dave F

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.
 
R

Ron Rosenfeld

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
 
Top