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...