| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spliting data
Hi, I need to split some data into two different cells: for example; Name Bob Thomas John Smith C Ward into FirstName LastName Bob Thomas John Smith C Ward They are all names... Cheers -- blander ------------------------------------------------------------------------ blander's Profile: http://www.excelforum.com/member.php...o&userid=36486 View this thread: http://www.excelforum.com/showthread...hreadid=565157 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Spliting data
highlight the row
Data....text to columns.....delimited...choose space as the delimiter This should do what you wish if there is a space between each first and last name. "blander" wrote: Hi, I need to split some data into two different cells: for example; Name Bob Thomas John Smith C Ward into FirstName LastName Bob Thomas John Smith C Ward They are all names... Cheers -- blander ------------------------------------------------------------------------ blander's Profile: http://www.excelforum.com/member.php...o&userid=36486 View this thread: http://www.excelforum.com/showthread...hreadid=565157 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Spliting data
cheers worked a treat!! -- blander ------------------------------------------------------------------------ blander's Profile: http://www.excelforum.com/member.php...o&userid=36486 View this thread: http://www.excelforum.com/showthread...hreadid=565157 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Spliting data
need your help again, really apreciate it :) I have all the data seperated.. except some of them contained salutations e.g. Name Mr Sam Fisher Bob Smith Mrs Carla O Toole WHICH IS NOW Name1 Mr Bob Mrs Name2 Sam Smith Carla Name3 Fisher O Name4 Toole So all the colums are out of order I have 40 000 records i need to sort Any way to seperate each colum according to spaces within the initial field?? Cheers -- blander ------------------------------------------------------------------------ blander's Profile: http://www.excelforum.com/member.php...o&userid=36486 View this thread: http://www.excelforum.com/showthread...hreadid=565157 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Spliting data
need your help again, really apreciate it :) I have all the data seperated.. except some of them contained salutations e.g. Name Mr Sam Fisher Bob Smith Mrs Carla O Toole WHICH IS NOW Name1 Mr Bob Mrs Name2 Sam Smith Carla Name3 Fisher O Name4 Toole So all the colums are out of order I have 40 000 records i need to sort Any way to seperate each colum according to spaces within the initial field?? Cheers -- blander ------------------------------------------------------------------------ blander's Profile: http://www.excelforum.com/member.php...o&userid=36486 View this thread: http://www.excelforum.com/showthread...hreadid=565157 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
| Importing Data | Excel Worksheet Functions | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
Hybrid Mode
