excel+courses - Splitting a cell

Comma Delimited Text

Highlight the range of cells where the first name and last name is, then select data > text to columns...

then when presented with the dialogue box, choose the top option, which says 'delimited', then click next.

After that, select the box that says 'spaces' and de-select any other boxes that may be ticked and then click next, then finish and voila!

There you have it...

Hope this helps

Paul