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
KIDZ-1960-1-SPCP	KIDZ
GUIDE-G6713	GUIDE
EC4R(1a)-ELR-15651-BK	EC4R

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: center"]3[/TD]

</tbody>

Sheet2​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B1[/TH]
[TD="align: left"]=LEFT(A1,MIN(FIND({"-","("},A1&"-(")-1))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[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!!