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.

Microsoft Excel is ubiquitous, but it's far more than a simple spreadsheet app — a huge array of powerful features lay within its cells.

Basic Formulas At their most basic, Excel formulas can perform basic math functions and display a solution. For example, the formula "=2+2" will display "4" in the cell.