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 them perform a calculation from the various numbers eg:

NUMBERS FROM TEXT.jpg

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.