Below is a possible solution to the challenge – Challenge 29 – Reverse (Flip) a Number String
You may use below formula to reverse a number string –
=SUMPRODUCT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)
*10^ROW(INDIRECT("1:"&LEN(A1)))/10)
Below is a possible solution to the challenge – Challenge 29 – Reverse (Flip) a Number String
You may use below formula to reverse a number string –
=SUMPRODUCT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)
*10^ROW(INDIRECT("1:"&LEN(A1)))/10)