Thread: Extracting Numeric data from a string

Hi

Please could someone help me with the following?

I need to extract numeric data only from strings that are mixed up with both numeric and alphanumeric data.

For example

Column A
8yrs 1month
10yrs 10months
1yr 1month
1yr 10months

I would like to get the following in two separate columns

Column B
8
10
1
1

Column C
1
10
1
10



Thanks

Roast