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