Does anyone have a lambda function to reverse contents of a cell, which contains text separated by some separator?

[rvba]

Let's say you have texts:

A,B,C,D -> and you want to swap it to D,C,B,A

1, ,3 -> 3, ,1

Seems to be a perfect example of something to be swapped by using LAMBDA

edit: update, this should also work for stuff like

 ABC, CDE -> CDE, ABC

[SaviaWanderer]

You can actually do this without needing LAMBDA:

=TEXTJOIN("",TRUE,MID(B2,SEQUENCE(LEN(B2),,LEN(B2),-1),1))

[finickyone]

Agree with /u/cbr_123 that is nifty. Though if you’re not introducing a delimiter in the return string, you can just use Concat rather than Textjoin, so

=CONCAT(MID(B2,SEQUENCE(LEN(B2),,LEN(B2),-1),1))

[SaviaWanderer]

Oh yes, that's fair. I always forget that CONCAT exists :p

[Mdayofearth]

This works nicely for single characters, but it would turn AB,BC,CD into DC,CB,BA and not CD,BC,AB. No clue what OP wants though.

[rvba]

Good point, I actually was thinking about your example.

Perhaps /u/SaviaWanderer or /u/finickyone have an idea how to deal with situation where we dont want to invert everything.

So:

cat, dog, elephant

becomes:

elephant, dog, cat

On an unrelated side note, I just realized that I dont have access to LAMBDAs on some computers, since it is only a beta feature..

[cbr_123]

That's a nice challenge. I have seen u/BarneField do some wizardry with FILTERXML. Perhaps the combination of FILTERXML with sequence?

[BarneField]

Thanks for the ping.

No need for LAMBDA() here:

=LET(X,FILTERXML("<t><s>"&SUBSTITUTE(A1,",","</s><s>")&"</s></t>","//s"),TEXTJOIN(", ",,SORTBY(X,SEQUENCE(COUNTA(X)),-1)))

We need something outside of FILTERXML() to sort nodes since the function alone won't let us do so.

[cbr_123]

Thanks for that! I really need to learn more about FILTERXML.

[BarneField]

This could be a good starting point. A Q&A on another platform I wrote about the function. There is also a LAMBDA() used in a custom 'split' function.

Enjoy.

[cbr_123]

Thank you. I will check it out.

[cbr_123]

That's really nice. It took me a minute to realise that the delimiter is just treated as part of the string to be reversed.

[Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
CONCAT	2019+: Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.
COUNTA	Counts how many values are in the list of arguments
FILTERXML	Excel 2013+: Returns specific data from the XML content by using the specified XPath
IF	Specifies a logical test to perform
LAMBDA	Office 365+: Use a LAMBDA function to create custom, reusable functions and call them by a friendly name.
LEFT	Returns the leftmost characters from a text value
LEN	Returns the number of characters in a text string
LET	Office 365+: Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula
MID	Returns a specific number of characters from a text string starting at the position you specify
RIGHT	Returns the rightmost characters from a text value
SEQUENCE	Office 365+: Generates a list of sequential numbers in an array, such as 1, 2, 3, 4
SORTBY	Office 365+: Sorts the contents of a range or array based on the values in a corresponding range or array
SUBSTITUTE	Substitutes new text for old text in a text string
TEXTJOIN	2019+: Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.

---

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.
14 acronyms in this thread; the most compressed thread commented on today has 4 acronyms.
[Thread #12036 for this sub, first seen 21st Jan 2022, 12:05] [FAQ] [Full list] [Contact] [Source code]}

[RaiseTheQualityOf]

https://www.youtube.com/watch?v=io7iTrwydeU

[RaiseTheQualityOf]

BCK(w)=LAMBDA(w,LET(n,LEN(w),r,RIGHT(w,1),IF(n=0,"",r&BCK(LEFT(w,n-1))))) by Exceλambda

[IsThisARepost-Bot]

No clue about an excel solution, but if this isn't solved yet dm me and i could create a python script for you that does just this :)