A formula to count characters in an Excel cell?

G

Griff

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

oldchippy

Griff said:
Need a formula to count the total number of characters within
spreadsheet
cell as opposed to the number of words. All help much appreciated.
Click to expand...
Hi Griff,

=LEN(A1)

will give you the answer

oldchippy :
 
D

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
 
Top