mahmed1
Well-known Member
- Joined
- Mar 28, 2009
- Messages
- 2,302
- 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