counting the number of characters in a cell

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

 

[Peo Sjoblom]

=LEN(A1)


--


Regards,


Peo Sjoblom

 

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

=LEN(A1) etc.

 

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

=LEN(cell_ref)


--ron

 

[bridgetv]

=LEN(A1) etc.

Thanks it worked!