This one-step add-on will divide the selected full names in your sheet into different columns with the name parts you choose to see.
Select the column with multipart names you want to split and open the tool in Extensions > Split Names > Start:
You will see the add-on window with a couple of settings:
Once you have the range and columns set, click on the Split button to get the selected name parts in a new column to the right of the original one:
Please contact us here