is Error help

[Jim]

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

 

[Bob Umlas]

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

 

[Don Guillett]

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

 

[David Biddulph]

=IF(A1="","",TRIM(LEFT(A1,FIND("-",A1)-1)))
If you want to trap for cell contents not including a hyphen, you may prefer
=IF(ISNUMBER(FIND("-",A1)),TRIM(LEFT(A1,FIND("-",A1)-1)),"")