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.

If you've ever had a list of first and last names that you wanted to separate Excel and Google Sheets make it easy. Here's how to do it in each application.