Reverse Numbers Formula

MrsFrankieH

Active Member
Joined
Mar 25, 2011
Messages
268
Office Version
  1. 365
Platform
  1. Windows
Hello Everyone!

My computer is Asus
My Operating system is Windows 10.

Can someone please help me with a formula that I can drag down (or up) to reverse numbers in a cells?
The range is 01 to 99.

Here is a sample:

Thank you in advance for your help and expertise.

Frankie
 

Attachments

  • Reversal.png
    Reversal.png
    18.7 KB · Views: 14

MrsFrankieH

Active Member
Joined
Mar 25, 2011
Messages
268
Office Version
  1. 365
Platform
  1. Windows
If you have the subscription version then it would be office 365 (which is newer than 2019). It will have everything that is in 2019 plus some new features as well.

The link contains a full guide on how to use XL2BB, there is not really anything that I can tell you which is not already explained there.
Thank you again Jason!!

I so appreciate you helping me with this!
I will give update (put correct version of subscription in my profile) and have a go at this first change I get (after I wake up lol).
Thanks again and I'm truly grateful!
 
Solution

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

mohadin

Well-known Member
Joined
Mar 22, 2015
Messages
614
Office Version
  1. 2013
Platform
  1. Windows
Hi Mohadin!
I don't have acumen in code. Do you know a formula that would reverse the numbers? I appreciate your expertise and effort.
Excel Formula:
=IF( MID(A1, 2, 1)<>"",MID(A1, 2, 1),0)&LEFT(A1, 1)
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
36,414
Office Version
  1. 2010
Platform
  1. Windows

ADVERTISEMENT

Here is another formula that you can try...
Excel Formula:
=MID(TEXT(A1,"00")&TEXT(A1,"00"),2,2)
 

mohadin

Well-known Member
Joined
Mar 22, 2015
Messages
614
Office Version
  1. 2013
Platform
  1. Windows
Ah May be you mean
Excel Formula:
=IF(A1<>"",IF( MID(A1, 2, 1)<>"",MID(A1, 2, 1),0)&LEFT(A1, 1),"")
You might replace each "," with ";"
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
36,414
Office Version
  1. 2010
Platform
  1. Windows
Here is another formula you can consider...
Excel Formula:
=MID(A1&TEXT(A1,"00"),LEN(A1),2)
 

Watch MrExcel Video

Forum statistics

Threads
1,113,890
Messages
5,544,878
Members
410,643
Latest member
sng
Top