View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default =TRIM(LEFT(B47,FIND(" ",B47)-1))

Hi,

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

"Jim" wrote:

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