Question: how to change the first name and last name in excel?
Answer: Enter the formula =MID(A2&" "&A2,FIND(" ",A2)+1,LEN(A2)) in a blank cell, says Cell C2. ... 
Press the F5 key to run this macro. ... 
In the following popping up dialog box, please enter an interval symbol (such as a space), and then click the OK button. ... 
Now the first name and last name in selected range are flipped.