Remove after Dash

[plank22]

Hello,

Column b2 over 500 sku's and I need to remove everything after the dash. Normally a find replace -* would do this but in this list o sku's some have one dash and some have two. If the sku has one dash remove everything -* and if it has two dashes remove everything after the second dash. Any idea how to do this?

Example

LED15008
15006-MP-34
15006-MP-35
85103-ORB
85103-SP
15005-3-34
15005-3-35
96905-MTP
88531-SB
88531-SP


Should be when finished

LED15008
15006-MP
15006-MP
85103
85103
15005-3
15005-3
96905
88531
88531

Thanks in advance

I also have another more complicated problem. Is there an area to get paid support?

[PaulM100]

This should do:
=IFERROR(LEFT(A1,FIND("^^",SUBSTITUTE(A1,"-","^^",LEN(A1)-LEN(SUBSTITUTE(A1,"-",""))))-1),A1)

This forum has Comercial Services if you want better ans faster responses. See here:
https://www.excelforum.com/payments.php

[FlameRetired]

Another way.

	A	B	C
1	LED15008	LED15008	=IFERROR(LEFT(A1,LOOKUP(1E+306,FIND("-",A1,ROW($1:$25)))-1),A1)
2	15006-MP-34	15006-MP
3	15006-MP-35	15006-MP
4	85103-ORB	85103
5	85103-SP	85103
6	15005-3-34	15005-3
7	15005-3-35	15005-3
8	96905-MTP	96905
9	88531-SB	88531
10	88531-SP	88531