View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Brian
 
Posts: n/a
Default LEN function in XL97

Zone wrote:
It's a misplaced parenthesis. Try
=RIGHT(A1,LEN(A1)-2)
James

Thanks to everybody. This is my Homer Simpson moment for today (I hope).