I have several thousand records where QBs combines a product SKU followed by the description in brackets. I need the SKU number only which varies in length. In the examples below I simply need the characters leading up to the open parenthesis less the space(s) between the SKU and description. I suspect this is relatively easy, but I don't know Excel well enough to create the formula.
<colgroup><col></colgroup><tbody>
</tbody>
1005T-BKWH (Hooey, Cody Ohl Black / White Trucker Cap - OSFA) |
1005T-BL ( "Cody Ohl" Hooey Blue / Gray Mesh 6-panel trucker with Gray Logo - OFSA) |
1005T-BLGY (Hooey, Cody Ohl Blue / Gray Trucker Cap - OSFA) |
1005T-BUGY (Hooey, Cody Ohl Maroon / Gray Trucker Cap - OSFA) |
<colgroup><col></colgroup><tbody>
</tbody>