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]

 

[dreid1011]

Perhaps this:

=LEFT(A2,FIND("(",A2)-2)

That is if the sample data you provided is an accurate representation of all your data.. if not, then you may need something else. And welcome to the board.

 

[Rick Rothstein]

Here is another formula that will also work...

=REPLACE(A2,FIND(" (",A2),999,"")

 

[Scott Huish]

There doesn't appear to be a space in the SKU, so you probably could just look for the first space:

=LEFT(A1,FIND(" ",A1&" ")-1)

 

[jhinkel]

I figured it would be an easy solution for you pros...took me all of 10 seconds to copy, adjust and replicate over 8000 records. Thanks so much. Now, if you have any fixes for 104 degree Texas heat, I'm all ears

 

[jtakw]

Hi,

Solution for your latest request:

Book1
	I	J
1	104 degree Texas heat	74
Sheet148

Cell Formulas
Range	Formula
J1	=LEFT(I1,3)-30&CHAR(176)

 

[jhinkel]

Tried it...stepped outside...still sweating

 

[Rick Rothstein]

Tried it...stepped outside...still sweating

Where in jtakw's posting does it say "step outside"?

 

[jtakw]

Tried it...stepped outside...still sweating

Where in jtakw's posting does it say "step outside"?

Might need Rick to come up with a VBA solution. :wink:

 

[Fluff]

How about

Sub AirConOn()
   Dim x As Long
   Do Until x = 80
      Range("B1") = "Current temprature is " & 104 - x & Chr(176)
      x = x + 10
      Application.Wait Now + TimeValue("00.00.02")
   Loop
End Sub