From Add-in Express:
Split Names for Microsoft Excel is an add-in for Microsoft Excel. It separates name from one cell to another cells. You can select just one cell within the column to save time and this smart add-in will catch up the whole column. Choose the parts into which you want to separate names and select the output location, more precisely the top left cell of the destination range and click Run to view your result.