Return the words in reverse order

You can return the words of a text string in reverse order by using this formula.

	A
1	First Middle Last
2	=RIGHT(A1, LEN(A1)-SEARCH(" ", A1)-1&" "&LEFT(A1, SEARCH(" ", A1)-1)) = #VALUE!

Built-in Functions

LEFT - The first or left most characters in a text string.
LEN - The number of characters in a text string.
RIGHT - The last or right most characters in a text string.
SEARCH - The starting position of a substring within a larger text string (not case sensitive).

User Defined Function

REVERSE - Returns the contents of a cell with all the characters reversed.

Related Formulas

Return the digits in reverse order