| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRIM FUNCTION...how to? | Excel Worksheet Functions | |||
| TRIM function | Excel Worksheet Functions | |||
| trim function | Excel Worksheet Functions | |||
| Trim Function | Excel Worksheet Functions | |||
| Need help with TRIM function | Excel Worksheet Functions | |||
Linear Mode
