mahmed1
Wellknown Member
 Joined
 Mar 28, 2009
 Messages
 2,222
 Office Version

 365
 2016
 Platform

 Windows
Hi Guys
If i have a number like this 1234567 and i would like to reverse them so they go in this order 7654321. What is the formula to do this and for text also. i.e A B C D E (TO) E D C B A?
AND Also say i also wanted a formula to reverse but not include the 0 at the end i.e if i had 1234567000 i want it to return 7654321 not the 0.
Thank You
If i have a number like this 1234567 and i would like to reverse them so they go in this order 7654321. What is the formula to do this and for text also. i.e A B C D E (TO) E D C B A?
AND Also say i also wanted a formula to reverse but not include the 0 at the end i.e if i had 1234567000 i want it to return 7654321 not the 0.
Thank You