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 ...

Separating first and last names in an Excel spreadsheet is a common task that can be time-consuming if done manually.