In this case, selecting the space delimiter will split these dual names into separate columns, even though you want to keep them together.

Learn how to separete ot split the Full name to First and Last name in Microsoft Excel, using the Delimiter or Separator function or Formula.

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.

You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.