| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting text
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting Text | New Users to Excel | |||
| Splitting a delimited text | Excel Discussion (Misc queries) | |||
| Splitting text to columns | Excel Worksheet Functions | |||
| splitting text in a cell.. | Excel Discussion (Misc queries) | |||
| Splitting Up Text in One Cell To Many | Excel Worksheet Functions | |||
Threaded Mode
