Removing Zeros in the middle of a drawing number

[Fola]

Hi All, how do I remove the zeros after the second "- " of my drawing numbers? Thanks

ST0042-E8020-0373 to be ST0042-E8020-373
ST0042-E9006-0021 to be ST0042-E9006-21
ST0041-E8060-0001 to be ST0042-E8060-1

Can I have a single formula to fix this? Thanks.

 

[Scott Huish]

The numbers you're providing now are not like your original sample:

ST0042-E8020-0373 to be ST0042-E8020-373
ST0042-E9006-0021 to be ST0042-E9006-21
ST0041-E8060-0001 to be ST0042-E8060-1

Your numbers had 3 blocks with a 4 digit number at the end.

Now, you're providing different style numbers.

 

[Scott Huish]

=TEXTBEFORE(A1,"-",-1)&TEXT(TEXTAFTER(A1,"-",-1),"-0")

 

[Fola]

This worked. Thank you very much.

 

[Peter_SSs]

=TEXTBEFORE(A1,"-",-1)&TEXT(TEXTAFTER(A1,"-",-1),"-0")

Perhaps I am not understanding what the latest sample data is like but is the TEXT() function actually required?
Would this do the same job?
=TEXTBEFORE(A1,"-",-1)&-TEXTAFTER(A1,"-",-1)

 

[Phuoc]

Another way:

=LEFT(A2,12)&-MID(A2,14,4)

 

[Scott Huish]

That's clever adding a negative number to the end to strip out the leading zeros. The only thing mine will do that those don't is if it's a single ending 0, my formula will keep it.

ST0042-E8020-0

but I don't know if that's actually a possibility or not.