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.

Excel mimics the capitalization and punctuation you use, so enter the names exactly as you want them to appear. Begin typing the next first and last name in the next cell in column C.

Let’s say you have student information in a worksheet where students’ last names, first names, and ID numbers are in Column A. If you want their first name and last name to appear in Column B, you ...