Automatically Split Full Names into Firstname SecondName and LastName using Power Query
If you frequently receive excel data that contains full names in one column and have to apply complex formulas to split the data each time, then this is the video for you.
We take you through the process of automating the splitting of the full names into first name,second name and last name which only need to be undertaken once.
Any subsequent data, you only need to paste it and refresh the excel file and automatically the splitting is done for you.
The steps include
1.Select the Column to split
2.Split the Column by Delimiter
3.Select the Delimiter
4.Rename the headers of the split Column
5.Close and Load the query