Thread: LEN function in XL97
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Zone
 
Posts: n/a
Default LEN function in XL97
It's a misplaced parenthesis. Try
=RIGHT(A1,LEN(A1)-2)
James

Reply With QuoteReply With Quote