Thread
:
Len & Trim Function
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Frederik[_3_]
external usenet poster
Posts: 63
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.
Reply With Quote
Frederik[_3_]
View Public Profile
Find all posts by Frederik[_3_]