Extract nontext values before character (1 Viewer)

[HeelNGville]

Thanks in advance for any assitance. I have searched the forums and was unable to return any results (perhaps the incorrect combination of keywords to search).

In any event, I have a spreadsheet that contains a text field in column C. The data in the text field is comprised of OEM part numbers/descriptions. For example:

Ex. 1 -Widget 324JKY 22" Blah Blah Blah etc
Ex. 2 -Widget 123456 7" blah blah blah

What I am attempting to retrieve is the 1st and/or 2nd nontext/numeric values to the left of the ". So the results of my 2 examples would yield:

Ex. 1 = 22
Ex. 2 = 7

Any assitance would be appreciated.

 

[chergh]

Take a look at the mid and instr functions

 

[shades]

Take a look at the mid and instr functions

Just a note, instr does not exist in Excel.

MID, RIGHT, and LEFT will be your options. If you need specific help with those, let me know.
________
Vapor Genie

 

[HeelNGville]

Thanks Shades.

I was able to extract everything to the left of the " with:

Inserted into "K2" =MID(C2,1,FIND("""",C2,1)-1)

and then I used

=RIGHT(K2,2)

to retriev the numeric values needed. This may not be the cleanest method, however it was the best results that I could produce at that juncture.

Thanks!