How to Extract Numbers from TextNumber String

To extract numbers from the textnumber string, you need to use Right Function, or check how to extract Text in the TextNumber String.

Formula:

Copy the formula and replace "A1" with the cell name that contains the text you would like to extract.

=RIGHT(A1,LEN(A1)- MIN(FIND({0,1,2,3,4,5,6,7,8,9}, A1 & "0123456789"))+1)

Example:

To extract numbers from the textnumber string "abc123".

The result returns "123".

Explanations:

Step 1: To merge the string with numbers from 0 to 9

Step 2: To figure out the position of each number in the new string

Step 3: Find the minimum location of each number

Step 4: Extract the numbers from the TextNumber String