Revers name

[sksanjeev786]

Hi Team,

I need a name in reverse formate as of now I can able to do with 2 words but while trying with 3 words not getting correct solution

Output : Verma Kumar Raj

Excel.xls
	F	G
62	Raj Kumar Verma	Kumar Verma Raj
Test (3)

Cell Formulas
Range	Formula
G62	G62	=MID(F62&" "&F62,FIND(" ",F62)+1,LEN(F62))

 

[arthurbr]

Perhaps Excel formula: Reverse text string | Exceljet

 

[sksanjeev786]

Perhaps Excel formula: Reverse text string | Exceljet

Sure, Sir I will check the above link you have provided....

 

[Micron]

Consider calling a function, then it won't matter how many words you want to reverse. In a standard module:

Function ReverseWordOrder(strIn As String) As String
Dim ary() As String, strOut As String, i As Integer

ary() = Split(strIn)
For i = UBound(ary) To 0 Step -1
   ReverseWordOrder = ReverseWordOrder & ary(i) & " "
Next

End Function

Then fill down
=ReverseWordOrder(A1) <<change to your cell address.

 

[lrobbo314]

Unwind with formulas and VBA.xlsm
	A	B
1	Raj Kumar Verma	Verma Kumar Raj
Sheet2

Cell Formulas
Range	Formula
B1	B1	=LET(x,FILTERXML("<a><b>" & SUBSTITUTE(A1," ","</b><b>") & "</b></a>","//b"),c,COUNTA(x),s,SEQUENCE(c,,c,-1),TEXTJOIN(" ",1,INDEX(x,s)))

 

[Fluff]

Another option, for 365 only

+Fluff 1.xlsm
	A	B
1
2	Raj Kumar Verma	Verma Kumar Raj
Main

Cell Formulas
Range	Formula
B2	B2	=LET(f,FILTERXML("<k><m>"&SUBSTITUTE(A2," ","</m><m>")&"</m></k>","//m"),TEXTJOIN(" ",,SORTBY(f,SEQUENCE(ROWS(f),,,-1))))

 

[sksanjeev786]

Thank you so much Team for your help with this !!!!

 

[Micron]

Those formulas make my head spin!
Please do let us know which way you go and mark this as solved when you're happy with the result.

 

[Joe4]

Perhaps Excel formula: Reverse text string | Exceljet

That seems to reverse all the letters, and it looks like they actually want to just reverse the order of the words (not the letters in the words).

 

[Fluff]

Glad to help & thanks for the feedback.