Reverse Numbers Formula

[MrsFrankieH]

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

 

[MrsFrankieH]

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!

 

[mohadin]

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.

=IF( MID(A1, 2, 1)<>"",MID(A1, 2, 1),0)&LEFT(A1, 1)

 

[Yongle]

For some reason, this formula stretched out the cell. Advice please?

What does "stretched out the cell" mean?

 

[MrsFrankieH]

=IF( MID(A1, 2, 1)<>"",MID(A1, 2, 1),0)&LEFT(A1, 1)

 

[MrsFrankieH]

Hi Mohadin, I put the formula in G1 and ran into the same problem (stretched rows). I'm not sure what I'm doing wrong but as I told Jason, I must learn VBA I think if I'm having difficulty with the formula.

Thank you so much for your help!!

 

[MrsFrankieH]

What does "stretched out the cell" mean?

Hello Yongle. I don't know the technical term but here's a screenshot of the problem.

 

[Rick Rothstein]

Here is another formula that you can try...

=MID(TEXT(A1,"00")&TEXT(A1,"00"),2,2)

 

[mohadin]

Ah May be you mean

=IF(A1<>"",IF( MID(A1, 2, 1)<>"",MID(A1, 2, 1),0)&LEFT(A1, 1),"")

You might replace each "," with ";"

 

[Yongle]

Hello Yongle. I don't know the technical term but here's a screenshot of the problem.

Looks like user error
Your formula is not a formula - it is text

 

[Rick Rothstein]

Here is another formula you can consider...

=MID(A1&TEXT(A1,"00"),LEN(A1),2)