Extract certain numbers from text placing them in columns

Hello,


I have part descriptions listed in column J. I need to pull the part descriptions out and place them in the correct column (ODL, ODW or IDL) as shown in the sample spreadsheet. My original spreadsheet has 6000+ rows.

ODL = Outside Dimension Length
ODW = Outside Dimension Width
IDW = Inside Dimension Width

Two senarios:
1. Example: Description states 2.00" OD X 1.00" ID will be broke down like so: 2.00 (minus the inch txt) will be listed in column (K) and 1.00 will be listed in column (M).

2. Example: Descpription states 2.00" x 1.00" will be broke down like so: 2.00 (minus the inch txt) will be listed in column (K) and the 1.00 will be listed in column (L).

Factors to consider:
A. In the description it won't always have a (") txt after the number.
B. Any description with one number should be placed in column (K). Example: Part is 8" square.

Any help would be most appreciated!

Jindon, Thank you so much! Worked like a charm!!!!