I have several cells in a column that look something like this:

Cell A1: abc 1234 def ghi

Cell A2: xxxx aa b 245 qqqqq

Cell A3: abcdefg hij kl mnopqr s

etc.

Is there an excel formula or combination of formulas I can use to identify:

(1) whether any given text string (such as those above) include numbers, and

(2) what the first number (which could contain 1-4 digits) contained in the text string is?

Thanks in advance!

- Steve

Cell A1: abc 1234 def ghi

Cell A2: xxxx aa b 245 qqqqq

Cell A3: abcdefg hij kl mnopqr s

etc.

Is there an excel formula or combination of formulas I can use to identify:

(1) whether any given text string (such as those above) include numbers, and

(2) what the first number (which could contain 1-4 digits) contained in the text string is?

Thanks in advance!

- Steve

## Comment