This time challenge is for flipping a number string. Excel VBA has got a function "StrReverse" which can be used to perform this task through VBA.
The challenge is to do this through a formula.
Let's say A1 = 70948
You formula should return a result of 84907
Note if you number string is 709480, your result will still be 84907 as leading zero doesn't have any meaning in a number string.
You may post your answer in comments section.
Note – Solution to this challenge will be published after 1 month i.e. on 6-Dec-15.
=MID(SUMPRODUCT(MID(A1,ROW($A$1:INDEX($A:$A,LEN(A1),1)),1)*10^(ROW($A$1:INDEX($A:$A,LEN(A1)))-LEN(A1)-1)),3,255)