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