Sometime you need to flip the first and last name within the cell. Mostly peoples use cut and paste method to easily switch or flip name in Excel sheet. You can also use retyping method of reverse the first name and last name within cells. These are the simple ways to reordering the first and last name. Now, in this guide we’ll discuss another way which quickly allows you to switch or flip name in Excel sheet.
Must Read: How to use Double VLookup in Excel
You can use MID function along with the combination of Find and Len functions to easily and quickly switch or flip name in Excel sheet. Before start discussion how to use the function to revert the first and last name first let’s start to know about these functions.
MID Function
MID function is used to returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.
Syntax of MID function:
MID(text, start_num, num_chars)
Text: It is an required argument. The text string containing the text string which you want to extract.
Start_num: This is another required argument. The position of the first character you want to extract in text. The first character in text has start_num 1, and so on.
Must Read: How to use Advance Backward VLookup in Reverse Order in Excel
Num_chars: This is third required argument. Specifies the number of characters you want MID to return from text.
Find Function
Find function used to count the characters. Find is a case sensitive function which returns the starting position of one text string within another text string.
Syntax of Find function:
FIND(find_text, within_text, [start_num])
Find_text: This required argument is the text which you want to find.
Within_text: This argument is that text which containing the text you want to find.
Start_num: This optional argument specify the character at which to start the searching the process.
LEN Function
LEN function is another important function which is used to return the number of characters within a text string.
Syntax of LEN function:
LEN(text)
Text: It is the required text argument which length you want to find including spaces.
Steps to switch or flip name in Excel
To start the switching or flipping the name first and last name in Excel you have to take few given simple steps, have a look.
Step 1: Prepare the following working to revers the first and last name within cells in Excel sheet.
Step 2: Type the following given formula in Cell B2 =MID(A2&” “&A2,FIND(” “,A2)+1,LEN(A2)) and press enter to get the result.
Step 3: Copy the formula of Cell B2 to rest of the cells in which you want to flip or switch the first and last name.
I hope this guide helps you to easily switch or flip name in Excel sheet. If you have any suggestion regarding this article then please write us your suggestion in the comment box. Thanks to all.