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.

Griff Wrote:
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.
Hi Griff,

=LEN(A1)

will give you the answer

oldchippy :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=568283

Try this:

=LEN(A1)

Hope this helps.

Pete

Griff wrote:
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.

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

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

--
Don Guillett
SalesAid Software

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