split first last name excel

Split First & Last Name Using Power Query

Sometimes, when you have a data table which includes full names of candidates in one column and you want to separate the full name into first name and surname in different columns. Split First & Last Name With Power Query This is a common task, but most people may use complex formulas to perform this...
Read More