Alison has attended:
Excel Intermediate course
Separating lists in an excel spreadsheet
Hi,
I've got a list of people's names (forenames and surnames) in one column in a spreadsheet.
I want to know if there is a way to separate the names into two columns i.e. forename in one and surname in another to save me having to manually cut and paste 500 names individually!
Please help.
Alison
RE: Separating lists in an excel spreadsheet
Hello Alison
Thank you for your question.
This is quite easily solved, you just need to make sure you have an extra blank column next to the column where the names are currently.
1. Select the column of names.
2. Go to Data - Text to Columns.
3. At step 1, choose Delimited, click Next.
4. At step 2, tick Space, click Next.
5. At step 3 click Next (you don't need to change anything at step 3); then click Finish.
I hope this helps.
Amanda
RE: Separating lists in an excel spreadsheet
Thank you Amanda,
I really appreciate it. I actually had a little explore along the tool bar and saw the text to columns which I thought sounded like the right thing but am grateful for you getting back to me so quickly.
I've actually passed on that bit of knowledge to a couple of colleagues now so thanks again!
Alison
