LinkBack URL
About LinkBacks
How can I writ ea formula which counts the characters in a cell?
Does it count the spaces too or not?
Thank you
Raphael
How can I writ ea formula which counts the characters in a cell?
Does it count the spaces too or not?
Thank you
Raphael
=len(cell)
and yes it does
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
If you want to count spaces, use hum's suggestion. If you want to exclude spaces, try this...
=LEN(SUBSTITUTE(A1," ",""))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
and for good measure
if you want to count the space only
=LEN(A1)-LEN(SUBSTITUTE(A1," ",""))
lol good 1 hum
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks