Quick formula need!

[Domroy]

I have some skus, and I need a formula that will cut off part of it. Here are some examples:

KIDZ-1960-1-SPCP
GUIDE-G6713
EC4R(1a)-ELR-15651-BK

Those are examples of different kinds. I need JUST the letters before the first hyphen, but I also need it to cut off if there's a parenthesis. So for the data above, I only need:

KIDZ
GUIDE
EC4R

Can someone help super fast? Thank you so much! I could build it, but I'd need more time than I have!

Judi

 

[Eric W]

Maybe:

	A	B
1	KIDZ-1960-1-SPCP	KIDZ
2	GUIDE-G6713	GUIDE
3	EC4R(1a)-ELR-15651-BK	EC4R

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet2​

Worksheet Formulas Cell Formula B1 =LEFT(A1,MIN(FIND({"-","("},A1&"-(")-1)) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[Joe4]

One way:

=LEFT(A1,MIN(IFERROR(FIND("-",A1),999),IFERROR(FIND("(",A1),999))-1)

EDIT: Too slow! Looks like Eric is a little faster, and his formula a little shorter.

 

[Rick Rothstein]

I have some skus, and I need a formula that will cut off part of it. Here are some examples:

KIDZ-1960-1-SPCP
GUIDE-G6713
EC4R(1a)-ELR-15651-BK

Those are examples of different kinds. I need JUST the letters before the first hyphen, but I also need it to cut off if there's a parenthesis. So for the data above, I only need:

KIDZ
GUIDE
EC4R

Can someone help super fast? Thank you so much! I could build it, but I'd need more time than I have!

Maybe...

=REPLACE(A1,FIND("-",SUBSTITUTE(A1&"-","(","-")),LEN(A1),"")

 

[Domroy]

You guys are the BOMB and made me a rock star! Thank you!

 

[Eric W]

Glad we could help!

 

[Domroy]

Me too! Thank you!!