With the Text Toolkit add-in for Excel, you can easily swap text in the selected cells. In this manual, find out how to use the Swap Text utility.
For example, if you've got "John Smith" and you want to turn it into "Smith John", your separator is space, so you press the Space key and then Enter. To swap by line break, press Shift + Enter and then Enter.
Another example, if you've got "Smith,John" and enter comma as a separator, you'll get "John,Smith".
For instance, you've got "AB CD EF" in your cell and you want to swap it by a space. If you select Separator occurrence: 1 and tick From the beginning, your data will be swapped according to the first space from the beginning, so it will become "CD EF AB".
If you enter Separator occurrence: 2 and tick the From the beginning radio button, you'll get "EF AB CD".