Issue
I have this google sheets input column on the left, I want to flip the string like shown in the output column.
Input Output
--------------
bats stab
live evil
meet teem
part trap
stop pots
Solution
Split the string to it's characters using regex delimiter, then REDUCE
the string using current&accumulator
(reversal happens here):
=REDUCE(,SPLIT(REGEXREPLACE(A2,,"🐾"),"🐾"),LAMBDA(a,c,c&a))
For a array, use BYROW
:
=BYROW(A2:INDEX(A2:A,COUNTA(A2:A)),LAMBDA(str,REDUCE(,SPLIT(REGEXREPLACE(str,,"🐾"),"🐾"),LAMBDA(a,c,c&a))))
Answered By - TheMaster Answer Checked By - Timothy Miller (PHPFixing Admin)
0 Comments:
Post a Comment
Note: Only a member of this blog may post a comment.