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

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

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

The Freeze feature in Excel ... names beyond the first screen; that is, column A remains stationary at left while you move your cursor to the right as far as needed (even to the very last column ...

This way, the full name ‘Jose Domingo Sanchez’ would be split into the first name ‘Jose’ and the last name ‘Domingo Sanchez’. Again, this would work for longer names as well.