To separate first and last names using delimiters: Excel will split the first and last names into two columns. You can also ...

Excel gives you two ways to split cells into columns: using delimiters, or using a manual fixed width. Splitting cells into columns is a convenient way to separate first and last names ...

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