| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Split column on first space
We FIND the first space and then use RIGHT & LEFT:
In B1: =LEFT(A1,FIND(" ",A1,1)-1) In C1: =MID(A1,FIND(" ",A1,1)+1,1000) -- Gary''s Student - gsnu200777 "rexmann" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Split column on first space
Job done, thank you
Rexmann "Gary''s Student" wrote: We FIND the first space and then use RIGHT & LEFT: In B1: =LEFT(A1,FIND(" ",A1,1)-1) In C1: =MID(A1,FIND(" ",A1,1)+1,1000) -- Gary''s Student - gsnu200777 "rexmann" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
