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.