Microsoft Excel's "Text to Columns" feature lets you divide this data using two methods. If the data has an obvious deliminator, such as a comma between the last and first name, the "Delimited ...

If you need to add a comma after the first word in each cell in Excel using the Replicate or Substitute function, read through this article.

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

Microsoft Excel comes with a lot of built-in functionality that doesn't restrict you to comparing data in two columns using only one method.