Len & Trim Function

[Daren]

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.

 

[Frederik]

=if(len(trimA2)=0,0,Len(Trim(A2)))

 

[Mike H]

Maybe

=MAX(0,LEN(TRIM(A2)))

Mike

 

[Dave Peterson]

or just:
=len(trim(a2))

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.

 

[Daren]

Thanks it worked. Does that also count spaces between text and numbers?

 

[Daren]

Thanks you.

=if(len(trimA2)=0,0,Len(Trim(A2)))

 

[Mike H]

Yes it does

Thanks it worked. Does that also count spaces between text and numbers?