==IF(A1="","",TRIM(LEFT(A1,FIND("-",A1)-1)))


"Jim" wrote in message
...
Hello,

I'm currently using the following formula:

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

How would I write this so that if the referred to cell is blank then the
cell I have the formula in shows blank instead of an error?

Thanks
Jim