| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split column on first space
Hi
I have a spreadsheet pulled into excel with a list of clients. Unfortunately the entire address appears in one cell and I want to pull the number details out at the front. Example 13 Blackstock Road 135 Smithy Street etc. Is there a way of splitting at the first space (but not the other spaces) kind regards Rexmann PS Using Excel 2003 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I split a column? | Excel Discussion (Misc queries) | |||
| ???[Ctrl Space] does not highlight Column | Excel Worksheet Functions | |||
| Text to columns, split at first space only | New Users to Excel | |||
| Split field based on number of characters and space | Excel Worksheet Functions | |||
| Can I divide a column at the first "space" occurance | Excel Worksheet Functions | |||
Threaded Mode
