The primary need to separate the First and Last names in Excel is to classify a group of employees or students and categorize them according to their first or last names. You can do this in two ways: ...

In previous versions of Excel, you had to combine first and last names using the Concatenate function, or its shortcut "&" method. Those methods are still valid in Excel 2013, but the combined data ...