Reverse the wording in a text string

[robindunne]

I'm hoping one of you good people can help me out. I have a number of client names where I need to reverse the wording. For example, where I have a client named "Smith A J Mr" I need a formula to return "Mr A J Smith". Some name have one initial and others have two.

 

[SunnyAlv]

Try this

 

[SunnyAlv]

Try this

=CHOOSECOLS(TEXTSPLIT(B2," ",10),SORT(SEQUENCE(COUNTA(TEXTSPLIT(B2," ",10))),,-1))

**MAKE SURE THERE IS NO SPACE AT THE END OF THE SENTENCE

*If there’s any unclear information please let me know

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)