Request for a new calc function, REVERSE(string), which reverses the order of characters in a string. REVERSE("ABC") = CBA A1=123 REVERSE(A1) = 321 Use case: provides a mechanism for sorting a list based on the end of strings rather than the start of strings - I'm working through long lists of geolocatable items and/or organisations & want to draw together location types or organisation types that have the same characteristics. I've found in practice that being able to sort by the reverse of a string nicely groups set of things. Illustration: https://twitter.com/Tagishsimon/status/1358616303226019847
You can solve it with a formula like: =TRANSPOSE(TEXTJOIN("";1;MID($A$1;LEN($A$1)-ROW(OFFSET($ZZ$1;0;0;LEN($A$1);1))+1;1))) Change the reference cell $A$1 for whatever you like.
I second this request. The use-case in the linked tweet mirrors my own. On one hand, having the request satisfied would increase the productivity of my pro bono work for Wikipedia and Wikidata; on the other, it is generically applicable across multiple scenarios. While I appreciate that a formula has been kindly provided by m.a.riosv, a function will be more convenient to use and less error prone.
I could not find such a function for Excel (just tried to find documentation online). Would it be a compatibility problem to add it?
(In reply to Buovjaga from comment #3) > I could not find such a function for Excel (just tried to find documentation > online). Would it be a compatibility problem to add it? Likely a showstopper. And Miguel shared a solution that is working out of the box. Could imagine that this also can be done with Regex.
No further comment, let's stick to the c1 solution.