How to flip the first and last name in cells in Excel?

Let's say you get a roster of names in one column, however, you need to flip the first name and last name in cells. Normally you will get into one cell and cut the last name, and then paste it before the first name, or retype the name again. It will be time-consuming and tedious if you use these traditional methods. Actually, there are several easy ways to flip or reverse the first name and last name in a single column quickly.

If you have installed Kutools for Excel, please do as following steps:

Step 1: Select the range that you want to reverse the first and last names.

Step 2: Click Kutools > Text > Reverse Text Order, see screenshot:

Step 3: In the Reverse Text dialog box, specify a separator your selected text string using, (in this case, I select Space option) and then click the OK button. You can see the results in the Preview pane. See screenshot:

Now all the first names and last names in the selected range have been reversed.