Len & Trim Function
 

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.

Len & Trim Function
 

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

--
met vriendelijke groetjes


"Daren" schreef in bericht
...
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.

Len & Trim Function
 

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.

Len & Trim Function
 

or just:
=len(trim(a2))



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.

--

Dave Peterson

Len & Trim Function
 

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.

Len & Trim Function
 

Thanks you.



"Frederik" wrote:

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

--
met vriendelijke groetjes


"Daren" schreef in bericht
...
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.

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.