Reversing a text and number string independent of upper or lower case

[ER_Neha]

Hello. I hope you are doing well. Thanks in advance.
I have a string, I want them to be reversed. I have given various formats of strings that contain text and number, I would be glad to get a solution in formula

Book1
	A	B
1	strings	Desired output
2	ABCDEF	FEDCBA
3	ABC	CBA
4	CAT	TAC
5	dog	god
6	Dog	goD
7	Dog	gOD
8	CAT123	321TAC
9	Cat50	05taC
Sheet1

 

[jasonb75]

Try this in B2

=CONCAT(MID(A2,LEN(A2)-ROW(INDIRECT("1:"&LEN(A2)))+1,1))

 

[ER_Neha]

Try this in B2

=CONCAT(MID(A2,LEN(A2)-ROW(INDIRECT("1:"&LEN(A2)))+1,1))

Thank you so much it worked!

 

[Peter_SSs]

If you happen to have a lot of these formulas and wanted to avoid the volatile function INDIRECT you could use the col B alternative below.
I think that you may not yet have the SEQUENCE function in your Excel 365(?) but when you do you could also use the col C formula.
And if your strings are all short like your samples, you could even use something like the col D option.

20 08 23.xlsm
	A	B	C	D
1	strings
2	ABCDEF	FEDCBA	FEDCBA	FEDCBA
3	ABC	CBA	CBA	CBA
4	CAT	TAC	TAC	TAC
5	dog	god	god	god
6	Dog	goD	goD	goD
7	Dog	goD	goD	goD
8	CAT123	321TAC	321TAC	321TAC
9	Cat50	05taC	05taC	05taC
Reverse

Cell Formulas
Range	Formula
B2:B9	B2	=CONCAT(MID(A2,LEN(A2)-ROW(INDEX(A:A,1):INDEX(A:A,LEN(A2)))+1,1))
C2:C9	C2	=CONCAT(MID(A2,SEQUENCE(LEN(A2),,LEN(A2),-1),1))
D2:D9	D2	=CONCAT(MID(A2,{9,8,7,6,5,4,3,2,1},1))

 

[ER_Neha]

If you happen to have a lot of these formulas and wanted to avoid the volatile function INDIRECT you could use the col B alternative below.
I think that you may not yet have the SEQUENCE function in your Excel 365(?) but when you do you could also use the col C formula.
And if your strings are all short like your samples, you could even use something like the col D option.

20 08 23.xlsm
	A	B	C	D
1	strings
2	ABCDEF	FEDCBA	FEDCBA	FEDCBA
3	ABC	CBA	CBA	CBA
4	CAT	TAC	TAC	TAC
5	dog	god	god	god
6	Dog	goD	goD	goD
7	Dog	goD	goD	goD
8	CAT123	321TAC	321TAC	321TAC
9	Cat50	05taC	05taC	05taC
Reverse

Cell Formulas
Range	Formula
B2:B9	B2	=CONCAT(MID(A2,LEN(A2)-ROW(INDEX(A:A,1):INDEX(A:A,LEN(A2)))+1,1))
C2:C9	C2	=CONCAT(MID(A2,SEQUENCE(LEN(A2),,LEN(A2),-1),1))
D2:D9	D2	=CONCAT(MID(A2,{9,8,7,6,5,4,3,2,1},1))

Thank you so much I wanted to know all the ways to do it, glad you replied.

 

[Peter_SSs]

Thank you so much I wanted to know all the ways to do it, glad you replied.

You're welcome.

 

[Peter_SSs]

I wanted to know all the ways to do it

In that case there is also a very simple user-defined function too.

Function Rev(s As String) As String
  Rev = StrReverse(s)
End Function

ER_Neha 1.xlsm
	A	B
1	strings
2	ABCDEF	FEDCBA
3	ABC	CBA
4	CAT	TAC
5	dog	god
6	Dog	goD
7	Dog	goD
8	CAT123	321TAC
9	Cat50	05taC
Reverse

Cell Formulas
Range	Formula
B2:B9	B2	=Rev(A2)