Splitting text
Thanks for all the help.
The formula Mike H submitted worked like a charm and was very simple and
straight forward.
Thanks so much!
"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?
|