You can easily split first and last words, or split column by delimiter or split column by number of characters in Excel with one click using out powerful tool Dose for Excel Add-In.
visit Dose for excel Add-In website:
https://zbrainsoft.com/excel-split/