Len & Trim Function
Yes it does
"Daren" wrote:
Thanks it worked. Does that also count spaces between text and numbers?
"Mike H" wrote:
Maybe
=MAX(0,LEN(TRIM(A2)))
Mike
"Daren" wrote:
I am trying to use the Len function to count the number of characters and
numbers in an adjacent cell. When I use this formula, I get an error:
=if(len)(trimA2))=0,0,Len(Trim(A2)))
What might be the problem?
Thanks.
|