Use Delimiters in Excel . One of the most straightforward ways to separate first and last names is by using delimiters in Excel.A delimiter is a character that separates different parts of text data.

Let us suppose a situation in which you have a list of full names of people. You intend to split these names into three parts – first name, middle name, and last name.

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