ExcelBanter - Counting characters

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Counting characters (https://www.excelbanter.com/excel-discussion-misc-queries/79872-counting-characters.html)

sdmccabe

Counting characters

Could you suggest a formula to count the total number of alpha-numeric
characters in an adjoining cell?

Zack Barresse

Counting characters

Hello there,

To count all characters in a cell, check out the LEN formula. To count
specifics, either all numbers or all alpha-characters, it becomes more
tricky.

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM

"sdmccabe" wrote in message
...
Could you suggest a formula to count the total number of alpha-numeric
characters in an adjoining cell?

Biff

Counting characters

=LEN(A1)

Biff

"sdmccabe" wrote in message
...
Could you suggest a formula to count the total number of alpha-numeric
characters in an adjoining cell?

All times are GMT +1. The time now is 08:36 PM.