A formula to count characters in an Excel cell?

[Guest]

Need a formula to count the total number of characters within a spreadsheet
cell as opposed to the number of words. All help much appreciated.

 

[oldchippy]

Need a formula to count the total number of characters within
spreadsheet
cell as opposed to the number of words. All help much appreciated.

Hi Griff,

=LEN(A1)

will give you the answer

oldchippy :

 

[Pete_UK]

Try this:

=LEN(A1)

Hope this helps.

Pete

 

[Don Guillett]

=Len(h6)
=LEN(SUBSTITUTE(H6," ",""))

Sub cc()
'total characters
MsgBox Len(Range("h6"))
'total not counting spaces
MsgBox Len(Replace(Range("h6"), " ", ""))
End Sub