Concatenation

Hello Sam,

Hope you enjoyed your Microsoft Excel courses with BEST Training.
Thank you for your question regarding splitting text lists.

The best way of doing this is to:

1. Select the cells you want to split
2. On the toolbar click on DATA, then TEXT TO COLUMNS.
3. Step through the wizard, choosing DELIMITED on the 1st step and using SPACE as the delimited on the 2rd step.

That should split the names off. If you have too many columns, you might want to then use CONCETENATION to join them back together again (remember to put the space back in!)

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Richard