How to Reverse a String with a formula

#1

I thought I would share a trick that I figured out recently. How to reverse a string value.

Here is the formula that I am using.

TRIM(CONCATENATE(Unique(SEQUENCE(Length(original),1)).FormulaMap(Middle(original,CurrentValue,1))))

I have a table that I enter the original string value into, and then in the resulting column, I put the formula in. It took a bit of work, but it works 100% of the time.

Let me know what you think.

2 Likes

#2

Here’s another way:

    FormulaMap( Sequence(1, Length(Word) ),
                Word.Middle(Length(Word) - CurrentValue + 1, 1 ) )
    .Join("")
2 Likes