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:
<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.
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.