CertFusion

3 Simple Methods to Reverse First and Last Name in Excel

If you need to reverse the order of first and last names (e.g., from "John Doe" to "Doe John"), Excel offers several methods to accomplish this. Here's how you can do it.

Method 1: Using a Formula

This method uses Excel functions to rearrange the name.

Steps:

  1. Identify the Column:

    • Assume the full name is in Column A, starting from cell A1.

  2. Insert a New Column:

    • Add a new column next to the full names for the reversed names.

  3. Use the Formula:

    • In the first cell of the new column, type: 
      =MID(A1,FIND(" ",A1)+1,LEN(A1)) & " " & LEFT(A1,FIND(" ",A1)-1)
      • FIND(" ",A1) locates the space between the first and last names.
      • MID extracts the last name.
      • LEFT extracts the first name.
      • & " " adds a space between the reversed names.

  4. Press Enter:

    • The formula will reverse the first and last names.

  5. Copy the Formula Down:

    • Drag the fill handle down to apply the formula to the rest of the rows.

Method 2: Using Flash Fill

Flash Fill is a quick and intuitive way to reverse names without formulas.

Steps:

  1. Type the Reversed Name:
    • In a new column, manually type the reversed name for the first row (e.g., "Doe John" for "John Doe").
  2. Activate Flash Fill:
    • Select the next cell in the column.
    • Go to Data > Flash Fill, or press Ctrl + E.
  3. Excel Fills the Column:
    • Excel will automatically reverse the names for the remaining rows.

Method 3: Using CertFusion’s Name Reverser

If you prefer a quick and online solution, CertFusion’s Name Reverser is an excellent option.

Steps:

  1. Access the Tool:

  2. Upload Your Excel File:

    • Upload the file containing full names.

  3. Reverse the Names:

    • The tool will automatically reverse the first and last names for you.

  4. Download the Result:

    • Once processed, download the file with reversed names.

Tips:

  • Consistent Formatting: Ensure names are consistently formatted (e.g., "First Last") for accurate results.
  • Backup Your Data: Always save a copy of your data before making changes.