Extract numbers from text into multiple columns

[Giraffe23]

I hope i am not repeating someone else's question but i couldn't find the answer to my question -

I have a column of text strings that i need to extract the numbers out of each text string but not as a long number, instead into separate columns in order to perform a calculation from the various numbers. eg:

A	B	C	D	E	F
100mic Gloss Film 1000mm x 100m on 78mm core	FP22GLO100001003K	22	1000	100	3
100mic Gloss Film 1400mm x 1400m x 78mm core	FP22GLO140014003F	22	1400	1400	3
125mic Gloss Film 230mm x 60m on 58mm core	FP23GLO023000602	23	230	60	2
125mic Gloss Film 230mm x 100m on 58mm core	FP23GLO023001002OUT	23	230	100	2
75mic Ultra Matt Film 110mm x 1000m on 78mm core	FR12MAT011010003	12	110	1000	3
75mic Ultra Matt Film 190mm x 500m on 78mm core	FR12MAT019005003	12	190	500	3
75mic Gloss Film 1400mm x 2000M on 78mm core	FR12GLO140020003GOLD	12	1400	2000	3
75mic Imagecare Gloss Film 305x75m on 25mm Imagecare	FR12IMA030500751GLOF	12	305	75	1

<tbody>
</tbody>

I have columns A & B and need to extract the numbers from either column A or B into columns C, D, E & F in order to perform a calculation of the amount of film used of the different types. Column C could read the micron thickness from Column A rather than the 2 digit code in Column B as this is just for sorting not calculating.

Thank you in advance for saving me a lot of time - I currently manually extract the numbers each month and there are about 1,000 rows each time.

 

[chicagocomputerclasses]

<table cellpadding="4px" border="1" cellspacing="1">
<tr><td bgcolor="#DFE3E8"></td><td align="center" width="444" bgcolor="#DFE3E8">A</td><td width="193.2" align="center" bgcolor="#DFE3E8">B</td><td width="138" align="center" bgcolor="#DFE3E8">C</td><td width="144" align="center" bgcolor="#DFE3E8">D</td><td width="129.6" align="center" bgcolor="#DFE3E8">E</td><td align="center" width="129.6" bgcolor="#DFE3E8">F</td></tr>
<tr><td bgcolor="#DFE3E8">1</td><td bgcolor="#FFFFFF">100mic Gloss Film 1000mm x 100m on 78mm core</td><td bgcolor="#FFFFFF">FP22GLO100001003K</td><td bgcolor="#FFFFFF">=MID(B1,3,2)+0</td><td bgcolor="#FFFFFF">=MID(B1,8,4)+0</td><td bgcolor="#FFFFFF">=MID(B1,12,4)+0</td><td bgcolor="#FFFFFF">=MID(B1,16,1)+0</td></tr>
<tr><td bgcolor="#DFE3E8">2</td><td bgcolor="#FFFFFF">100mic Gloss Film 1400mm x 1400m x 78mm core</td><td bgcolor="#FFFFFF">FP22GLO140014003F</td><td bgcolor="#FFFFFF">22</td><td bgcolor="#FFFFFF">1400</td><td bgcolor="#FFFFFF">1400</td><td bgcolor="#FFFFFF">3</td></tr>
<tr><td bgcolor="#DFE3E8">3</td><td bgcolor="#FFFFFF">125mic Gloss Film 230mm x 60m on 58mm core</td><td bgcolor="#FFFFFF">FP23GLO023000602</td><td bgcolor="#FFFFFF">23</td><td bgcolor="#FFFFFF">230</td><td bgcolor="#FFFFFF">60</td><td bgcolor="#FFFFFF">2</td></tr>
<tr><td bgcolor="#DFE3E8">4</td><td bgcolor="#FFFFFF">125mic Gloss Film 230mm x 100m on 58mm core</td><td bgcolor="#FFFFFF">FP23GLO023001002OUT</td><td bgcolor="#FFFFFF">23</td><td bgcolor="#FFFFFF">230</td><td bgcolor="#FFFFFF">100</td><td bgcolor="#FFFFFF">2</td></tr>
<tr><td bgcolor="#DFE3E8">5</td><td bgcolor="#FFFFFF">75mic Ultra Matt Film 110mm x 1000m on 78mm core</td><td bgcolor="#FFFFFF">FR12MAT011010003</td><td bgcolor="#FFFFFF">12</td><td bgcolor="#FFFFFF">110</td><td bgcolor="#FFFFFF">1000</td><td bgcolor="#FFFFFF">3</td></tr>
<tr><td bgcolor="#DFE3E8">6</td><td bgcolor="#FFFFFF">75mic Ultra Matt Film 190mm x 500m on 78mm core</td><td bgcolor="#FFFFFF">FR12MAT019005003</td><td bgcolor="#FFFFFF">12</td><td bgcolor="#FFFFFF">190</td><td bgcolor="#FFFFFF">500</td><td bgcolor="#FFFFFF">3</td></tr>
<tr><td bgcolor="#DFE3E8">7</td><td bgcolor="#FFFFFF">75mic Gloss Film 1400mm x 2000M on 78mm core</td><td bgcolor="#FFFFFF">FR12GLO140020003GOLD</td><td bgcolor="#FFFFFF">12</td><td bgcolor="#FFFFFF">1400</td><td bgcolor="#FFFFFF">2000</td><td bgcolor="#FFFFFF">3</td></tr>
<tr><td bgcolor="#DFE3E8">8</td><td bgcolor="#FFFFFF">75mic Imagecare Gloss Film 305x75m on 25mm Imagecare</td><td bgcolor="#FFFFFF">FR12IMA030500751GLOF</td><td bgcolor="#FFFFFF">12</td><td bgcolor="#FFFFFF">305</td><td bgcolor="#FFFFFF">75</td><td bgcolor="#FFFFFF">1</td></tr>
<tr><td colspan="7"></td></tr>
<tr><td colspan="7" bgcolor="#D7E7F9">Sheet1</td></tr>
</table>