Return the words in reverse order

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

 A
1First 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 position of a substring within a larger text string.


User Defined Function

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


Related Formulas

Return the digits in reverse order


© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top