Hi,

Try

=LEFT(A1,MATCH(TRUE,ISERR(--MID(A1,ROW($1:$1000),1)),0)-1)
=MID(A1,MATCH(TRUE,ISERR(--MID(A1,ROW($1:$1000),1)),0),100)

Both array entered - press Shift+Ctrl+Enter to enter them

If this helps, please click the Yes button,

Cheers,
Shane Devenshire

"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?