Thread: =TRIM(LEFT(B47,FIND(" ",B47)-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(B47,FIND(" ",B47)-1))
Hello,

How do I write this formula so that the result is a blank cell if B47 is
blank? I get a #VALUE now.

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

Thanks so much for hte help
Reply With QuoteReply With Quote