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.

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.