Thread: =TRIM(LEFT(B50,FIND(" ",B50)-1))
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
  
Posts: 615
Default =TRIM(LEFT(B50,FIND(" ",B50)-1))
Hello,

Thanks for the help. How would I write this formula so that it avoids
errors if the referenced cell is blank?

=TRIM(LEFT(B50,FIND(" ",B50)-1))

Thanks
Jim
Reply With QuoteReply With Quote