How to flip first and last names in Excel (3 easiest ways)
A free Office suite fully compatible with Microsoft Office
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.
Was this helpful?
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to compare two excel sheets and highlight differences
- 4. How to copy file names in Excel from a folder?
- 5. How to color cell based on value in Excel?
- 6. How to add month name from date in Excel formula