manuprashar
New Member
- Joined
- Sep 22, 2002
- Messages
- 1
I am looking for a function that will help me count characters[text or numbers] in a cell
All help is appreciated,
regards,
All help is appreciated,
regards,
On 2002-09-23 14:11, PaddyD wrote:
or, if there might be blanks / spaces that you don't want to count:
=LEN(A1)-(LEN(A1)-LEN(SUBSTITUTE(A1," ","")))
Paddy
=LEN(SUBSTITUTE(A1," ","")
[SIZE=-1][ This Message was edited by: aladin akyurek on 2002-09-23 22:20 ][/SIZE]
"Word". | 7 =len() |
This formula would omit characters like , " ' . [space] and counts rest.
=LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"'",""),"""",""),".",""),",","")," ",""))
That formula counts characters like digits, colons, semi-colons, slashes, dashes, and so on. Is that what you actually wanted? Or did you just want to count letters only (and ignore all the rest of the characters)? If so, then give this formula a try...thanks a lot ... its working
hi i m looking for a formula which helps me to count how many cells in a row not a blank cells only wording cells .
like Ex:-
the to or one 4
kinldy help on the same