And if you're going to use trim, you don't need to subtract 1. The =trim() will
remove the trailing space.

=TRIM(LEFT(B47,FIND(" ",B47&" ")))



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

--

Dave Peterson