Tip Printed from ExcelTip.com

---

Reversing the Word Order within a String


Problem:

Reversing the order of words in each of the two-word strings in column A.

Solution:
Use the RIGHT, LEN, FIND, and LEFT functions as shown in the following formula:
=RIGHT(A2,LEN(A2)-FIND(" ",A2))&" "&LEFT(A2,FIND(" ",A2)-1)