counting the number of characters in a cell
 

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.

counting the number of characters in a cell
 

=LEN(A1)


--


Regards,


Peo Sjoblom


wrote in message
...
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.

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.

counting the number of characters in a cell
 

On Tue, 18 Dec 2007 13:11:06 -0800 (PST), 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(cell_ref)


--ron

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!