Thanks, this worked just like I needed it to and was very simple.

"Mike H" wrote:

Hi,

With your string in a1 put this in B1 to extract the numbers

=LOOKUP(10^23,--MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"012345 6789")),ROW(INDIRECT("1:"&LEN(A1)))))

Then this in c1 to extract the name
=RIGHT(A1,LEN(A1)-LEN(B1))

Drag down as required

Mike

"LLG-CN" wrote:

I have a spreadsheet that contains a column that has numbers and text of
varying lengths that I need to split into 2 columns.

Example: 123John Doe
1234Jane Doe

I can't split it using the Text To Columns function because there's nothing
delimited the text and the fixed width doesn't work because the numbers
preceeding the text are varying lengths.

Does anyone know a way to extract the data?
Is there something that extracts numerals vs characters?