View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daren Daren is offline
external usenet poster
 
Posts: 162
Default 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.