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