WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to flip first and last names in Excel (3 easiest ways)

July 22, 2022
29.5K Views

Perfecting your Excel skills is essential to becoming a professional. Learning how to format data, create filters and complex formulas are just some of the things you need to know to become a true Excel pro. One of the most important things you can do for your skills is to find out which formulas in Excel return specific values. Sometimes while working with the name, we need  to flip the first  and the last one for different purposes。

When you're looking to add a new first and last name to your Excel file, but aren't sure how to go about doing it, this is the article for you! By showing you step-by-step instructions on how to change your first and last name with simple steps, this guide will show you just how easy it is, you can try any of the methods given below。


How to flip first and last names in Excel using the Mid function

Mid function efficiently flips first and last names in excel , here‘s how to use it step by step

1. We want to reverse this name and put out input in the D column.

2.The syntax for this will be.

=MID(A2& &A2,FIND( ,A2)+1,LEN(A2))

3.The result we get is the name getting flipped.


How to flip first and last names in Excel using the Replace function

The next handy function for flipping the first and last name is the Replace function

The syntax of replace function is as follow:

=REPLACE (Cell position ,1,SEARCH( ,Cell position),)& &LEFT(Cell position,SEARCH( ,Cell position )-1)

1.Taking the previous scenario again, we will now learn how to apply this function.

2.The location of cell is A2, so our formula in this case becomes

 =REPLACE (A2,1,SEARCH( ,A2),)& &LEFT(A2,SEARCH( ,A2)-1)

3.Applying this formula ,we get.

4.Now we have learned how to flip first and last names in excel using Replace function.

How to flip first and last names in Excel using the Right function

Just like Replace and Mid, right is another function that’s used to flip the first and last name. To get these names, you can go through each person in your spreadsheet and add their first name and last name to a column. Then, you can use this column as a reference for changing their names throughout your spreadsheet. the syntax of this function is

=RIGHT(Cell position,LEN(A2)-SEARCH( , Cell position))& &LEFT(Cell position,SEARCH( , Cell position)-1)

1. Let’s apply it to the same case as before.

2. Since our cell position is A2, our syntax will be

=RIGHT(A2,LEN(A2)-SEARCH( ,A2))& &LEFT(A2,SEARCH( ,A2)-1)

3.Now we have learned how to flip first and last names in excel using the Right function

Did you learn about how to flip first and last names in excel using different methods You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets, and PowerPoint Slides?

You can also download WPS Office to edit the word documents, excel, and PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience. 

 

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.