Extract Data until reach Number in the string.

[myexcel211]

Hello all,
I am rather new to excel and I would love to learn more. Using image below.

The data will be always in format below. Is there any formula that I can use to extract the data using LEFT function that would return any text from right until it sees the first numbers? In this case, I would like cell B1 to return Started in Industrial Age? Any suggestions, helps would greatly appreciate. Thank you!

 

[jtakw]

Hi,

Although you say "data will always in format below", the Length of Text and/or numbers may vary.
I highly recommend showing at least a handful of possible different text strings for potential helpers to review.
And preferably using XL2BB, link to download and instructions in my signature.

 

[Peter_SSs]

Welcome to the MrExcel board!

You could try this. If this is not it then more samples as requested by jtakw please, together with the expected results.

22 01 26.xlsm
	A	B
1	123 The United States History1 988 Started In Industrial Age	Started In Industrial Age
Extract

Cell Formulas
Range	Formula
B1	B1	=TRIM(REPLACE(A1,1,LOOKUP(1,-MID(A1,ROW(INDEX(A:A,1):INDEX(A:A,LEN(A1))),1),ROW(INDEX(A:A,1):INDEX(A:A,LEN(A1)))),""))

 

[myexcel211]

Hi,

Although you say "data will always in format below", the Length of Text and/or numbers may vary.
I highly recommend showing at least a handful of possible different text strings for potential helpers to review.
And preferably using XL2BB, link to download and instructions in my signature.

Jtakw, thank you for pointing it out. Sorry for lack of more samples.

 

[myexcel211]

Welcome to the MrExcel board!

You could try this. If this is not it then more samples as requested by jtakw please, together with the expected results.

22 01 26.xlsm
	A	B
1	123 The United States History1 988 Started In Industrial Age	Started In Industrial Age
Extract

Cell Formulas
Range	Formula
B1	B1	=TRIM(REPLACE(A1,1,LOOKUP(1,-MID(A1,ROW(INDEX(A:A,1):INDEX(A:A,LEN(A1))),1),ROW(INDEX(A:A,1):INDEX(A:A,LEN(A1)))),""))

Peter_SSs, thank you so very much! This is extremely complex formula. It works perfectly. I sure will study this! Thanks again!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.