reverse a series of numbers from 1 cell into another
On Nov 15, 11:05 am, wrote:
How can I reverse numbers from one cell into another? Example A1
contains 64082... B1 (I want to show) 28064. Any suggestions would be
appreciated. Thanks.
Hi
this is an arrayformula....has to be entered with ctrl+shift+enter
instead
of only enter:
=TEXT(SUMPRODUCT(MID(A1,ROW(INDIRECT("1:" & LEN(A1))),
1)*10^(ROW(INDIRECT("1:" & LEN(A1)))-1)),REPT("0",LEN(A1)))
hth
Carlo
|