A formula to count characters in an Excel cell?

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

[oldchippy]

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

PS - If you have spaces either before of after and you do not wish to count these

=LEN(TRIM(A1))

[Pete_UK]

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.

[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

--
Don Guillett
SalesAid Software
[email protected]
"Griff" <[email protected]> wrote in message
news:[email protected]...
> 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.