|
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 10:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com