Delete first character if it is 0

[TAnderson]

I need a formula that removes the 0 from the beginning of this cell anytime it is 0. This needs to be used in conjunction with my formula to extract the data before the first _. For example:

066131_3Q12_F_24C2_D.tif

I need to extract 066131 but then automatically delete the 0.

391761_3Q12_F_24E2_D.tif

In this example I would just extract the 391761.

I'm currently using this formula to do the extraction: =MID(E2,1,FIND("_",E2,1)-1)

Thanks!

[ChemistB]

=IF(LEFT(E2,1)="0",MID(E2,2,FIND("_",E2,1)-2, MID(E2,1,FIND("_",E2,1)-1))
Does that work for you?

[TAnderson]

For some reason it says I have too many arguments in the formula.

[ChemistB]

Oops, forgot a )

Try this
=IF(LEFT(E2,1)="0",MID(E2,2,FIND("_",E2,1)-2), MID(E2,1,FIND("_",E2,1)-1))

[martindwilson]

=MID(E2,1,FIND("_",E2,1)-1)+0
is another option if its always a number ,mind you that would strip of all leading zeros

[TAnderson]

Perfect!!! Both options worked great and your second option (deleting all leading zeros) solved a problem I didn't even think about. Thank you!