Try this...

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

--
Biff
Microsoft Excel MVP


"Jim" wrote in message
...
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