counting characters in a cell 2

[dreadnaught]

I am looking for the formula to count the number of characters in a specific cell. Example a cell containing "HELLO" would return a value of 5. Can anyone help?

 

[ETID]

if cell A1 contained "Hello" then this formula will return the character count

in B1

=len(a1)

 

[questril]

Use

=LEN(text)

where text is the reference to the cell containing the text string you want to count.