Excel Guides

How to Reorder Last Name and First Name in Excel

If you have a list of names in an Excel spreadsheet and need to reverse the order of the last name and first name (i.e. change "John Smith" to "Smith John"), there are a few different ways you can do this.

One way is to use the Text to Columns feature. To do this:

  1. Select the column containing the names
  2. Click the Data tab on the ribbon
  3. Click Text to Columns
  4. In the Convert Text to Columns Wizard, select Delimited
  5. Click Next
  6. Check the box for "Space"

  7.              (If you have other delimiters in your data, such as commas or tabs, you can check those boxes as well)

         7. Click "Finish"

     8. The last names will now be in column A and the first names will be in column B.

     9. You can now delete column B if you want, or you can leave it there.

    10. To put the last name and first name in the reverse order, we'll use a simple concatenation formula.

    11. In cell C1, enter the following formula: =B1 &" " & A1


    12. Press Enter.

    13. Double-click the fill handle (the small square in the bottom-right corner of C1) to copy the formula down to the other cells in column C.


    14. And that's it! You should now have a list of names in reverse order, with the last name first and the first name second.

    Move beyond 

    Excel

    Get started with Causal today.
    Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.