Reverse Text in Excel (4 Ways)
To turn Hana into anaH, Excel 365 can do it with one formula. In older versions, use a one-line VBA function, or Power Query’s Text.Reverse. Excel 365CONCAT + MID + SEQUENCE Any versionStrReverse in VBA Power QueryText.Reverse 1. Formula (Excel 365) =CONCAT(MID(B3,SEQUENCE(LEN(B3),,LEN(B3),-1),1))Copy Step For “Hana” LEN(B3) 4 SEQUENCE(4,,4,-1) {4;3;2;1}, counting down MID(B3,{4;3;2;1},1) {“a”;”n”;”a”;”H”} CONCAT(…) anaH … Read more