Question: how to change first name to last 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.