Extracting data from a cell

[jhinkel]

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.

[TABLE="width: 592"]
<colgroup><col></colgroup><tbody>[TR]
[TD]1005T-BKWH (Hooey, Cody Ohl Black / White Trucker Cap - OSFA)[/TD]
[/TR]
[TR]
[TD]1005T-BL ( "Cody Ohl" Hooey Blue / Gray Mesh 6-panel trucker with Gray Logo - OFSA)[/TD]
[/TR]
[TR]
[TD]1005T-BLGY (Hooey, Cody Ohl Blue / Gray Trucker Cap - OSFA)[/TD]
[/TR]
[TR]
[TD]1005T-BUGY (Hooey, Cody Ohl Maroon / Gray Trucker Cap - OSFA)[/TD]
[/TR]
</tbody>[/TABLE]

 

[jhinkel]

I'm back...

Now I need to extract the verbiage between the brackets...anybody have any ideas?

[TABLE="class: cms_table, width: 592"]
<tbody style="border-collapse: collapse; border-spacing: 0px 0px; font-size: 13px; margin-bottom: 0px;">[TR]
[TD]1005T-BKWH (Hooey, Cody Ohl Black / White Trucker Cap - OSFA)[/TD]
[/TR]
[TR]
[TD]1005T-BL ( "Cody Ohl" Hooey Blue / Gray Mesh 6-panel trucker with Gray Logo - OFSA)[/TD]
[/TR]
[TR]
[TD]1005T-BLGY (Hooey, Cody Ohl Blue / Gray Trucker Cap - OSFA)[/TD]
[/TR]
[TR]
[TD]1005T-BUGY (Hooey, Cody Ohl Maroon / Gray Trucker Cap - OSFA)[/TD]
[/TR]
</tbody>[/TABLE]

 

[jtakw]

Would there be anything After the closing bracket ")" ??

 

[Rick Rothstein]

I'm back...

Now I need to extract the verbiage between the brackets...anybody have any ideas?

[TABLE="class: cms_table, width: 592"]
<tbody style="border-collapse: collapse; border-spacing: 0px 0px; font-size: 13px; margin-bottom: 0px;">[TR]
[TD]1005T-BKWH (Hooey, Cody Ohl Black / White Trucker Cap - OSFA)[/TD]
[/TR]
[TR]
[TD]1005T-BL ( "Cody Ohl" Hooey Blue / Gray Mesh 6-panel trucker with Gray Logo - OFSA)[/TD]
[/TR]
[TR]
[TD]1005T-BLGY (Hooey, Cody Ohl Blue / Gray Trucker Cap - OSFA)[/TD]
[/TR]
[TR]
[TD]1005T-BUGY (Hooey, Cody Ohl Maroon / Gray Trucker Cap - OSFA)[/TD]
[/TR]
</tbody>[/TABLE]

Give this formula a try...

=REPLACE(LEFT(A1,LEN(A1)-1),1,FIND("(",A1),"")

 

[jtakw]

Another way:

Book1
	A	B
1	1005T-BKWH (Hooey, Cody Ohl Black / White Trucker Cap - OSFA)	Hooey, Cody Ohl Black / White Trucker Cap - OSFA
2	1005T-BL ( "Cody Ohl" Hooey Blue / Gray Mesh 6-panel trucker with Gray Logo - OFSA)	"Cody Ohl" Hooey Blue / Gray Mesh 6-panel trucker with Gray Logo - OFSA
3	1005T-BLGY (Hooey, Cody Ohl Blue / Gray Trucker Cap - OSFA)	Hooey, Cody Ohl Blue / Gray Trucker Cap - OSFA
4	1005T-BUGY (Hooey, Cody Ohl Maroon / Gray Trucker Cap - OSFA)	Hooey, Cody Ohl Maroon / Gray Trucker Cap - OSFA
Sheet258

Cell Formulas
Range	Formula
B1	=TRIM(SUBSTITUTE(MID(A1,FIND("(",A1)+1,255),")",""))

Edit: Added TRIM for possible leading space after extraction (2nd sample)

 

[jhinkel]

Perfect...Thanks! Wish I could figure this out myself, but I can hardly follow the statement logic

 

[jtakw]

You're welcome.

 

[jhinkel]

Sorry I missed your first question, but, as you state, the trim addressed this possibility. This worked as well...thanks!