How to Extract Text in the TextNumber String

To extract the text portion from the textnumber string, you need to use Left Function, or check how to extract Numbers from TextNumber String.

Formula:

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

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

Example:

To extract the text from the text string "abc123".

The result returns "abc".

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 Text from the String