Today’s function is REVERSE_TEXT. Returns the text in reverse order.
BY/
Mark ProctorMark Proctor
,LAMBDA(text=
LET( Length,
LEN(text), Array,MID(text,SEQUENCE(Length),1),
ReverseArray,SORTBY(Array,SEQUENCE(Length,1,Length),-1), Result,TEXTJOIN("",FALSE,ReverseArray),
Result))
-----
=
TEXTJOIN(" ",TRUE,MAP(TEXTSPLIT(M2,," "),LAMBDA(a,CONCAT(TAKE(SORT(HSTACK(SEQUENCE(LEN(a)),MID(a,SEQUENCE(LEN(a)),1)),,-1),,-1)))))
ليست هناك تعليقات:
إرسال تعليق