Extracting Numeric data from a string

[roasty_1]

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

[sweep]

Hi,

In column B,

=LEFT(A1,FIND("y",A1)-1)

In column C


=MID(A1,FIND(" ",A1)+1,FIND("m",A1)-FIND(" ",A1)-1)