Return the words in reverse order

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

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 starting 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

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