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

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
11,009
Office Version
  1. 2019
Platform
  1. Windows
My computer is Asus
My Operating system is Windows 10.
We just need to know which version of Excel you're using (please update your profile so we don't have to ask or assume every time). Computer make and windows version should not make any difference.

It would also be helpful if you post your examples using XL2BB instead of screen captures (see link in my signature at the bottom of this post).
Book1
ABCDEFGHIJK
1671428596070418295
223455358623254358526
Sheet1
Cell Formulas
RangeFormula
G1:K2G1=--CONCAT(MID(TEXT(A1,"00"),{2,1},1))
 

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
4,050
Office Version
  1. 365
Platform
  1. MacOS
have a read here
Various solutions including VBA to reverse numbers in a cell of any length number in the cell
 

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,871
Office Version
  1. 365
Platform
  1. Windows
How about

=VALUE(RIGHT(A1,1)&LEFT(TEXT(A1,"00"),1))
 

mohadin

Well-known Member
Joined
Mar 22, 2015
Messages
614
Office Version
  1. 2013
Platform
  1. Windows

ADVERTISEMENT

Or
VBA Code:
Function rever(TargetCell As Range) As Double
    rever = IIf(Mid(TargetCell, 2, 1) <> "", Mid(TargetCell, 2, 1), 0) & Left(TargetCell, 1)
End Function

Excel Formula:
=rever(A1)
 

MrsFrankieH

Active Member
Joined
Mar 25, 2011
Messages
268
Office Version
  1. 365
Platform
  1. Windows
We just need to know which version of Excel you're using (please update your profile so we don't have to ask or assume every time). Computer make and windows version should not make any difference.

It would also be helpful if you post your examples using XL2BB instead of screen captures (see link in my signature at the bottom of this post).
Book1
ABCDEFGHIJK
1671428596070418295
223455358623254358526
Sheet1
Cell Formulas
RangeFormula
G1:K2G1=--CONCAT(MID(TEXT(A1,"00"),{2,1},1))
Hi Jason!
I have the latest version (subscription), so Excel 19?
Some else asked me to do that same thing and I had no success (I'm not the most technical person in the world). Thank you so much Jason!!
Could you tell me where I would put the XL2BB ?

Thanks again!!

Frankie :)
 

MrsFrankieH

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

ADVERTISEMENT

have a read here
Various solutions including VBA to reverse numbers in a cell of any length number in the cell

have a read here
Various solutions including VBA to reverse numbers in a cell of any length number in the cell
Hello
We just need to know which version of Excel you're using (please update your profile so we don't have to ask or assume every time). Computer make and windows version should not make any difference.

It would also be helpful if you post your examples using XL2BB instead of screen captures (see link in my signature at the bottom of this post).
Book1
ABCDEFGHIJK
1671428596070418295
223455358623254358526
Sheet1
Cell Formulas
RangeFormula
G1:K2G1=--CONCAT(MID(TEXT(A1,"00"),{2,1},1))
I've updated my profile Jason! Thank you for the tip. Unfortunately I haven't explored writing script yet, just formulas but this gives me something to work on!!

Thank you so much, I truly appreciate your help and I look forward to exploring VBA! :)
 

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
11,009
Office Version
  1. 2019
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.
 

MrsFrankieH

Active Member
Joined
Mar 25, 2011
Messages
268
Office Version
  1. 365
Platform
  1. Windows
Or
VBA Code:
Function rever(TargetCell As Range) As Double
    rever = IIf(Mid(TargetCell, 2, 1) <> "", Mid(TargetCell, 2, 1), 0) & Left(TargetCell, 1)
End Function

Excel Formula:
=rever(A1)
Hello
Or
VBA Code:
Function rever(TargetCell As Range) As Double
    rever = IIf(Mid(TargetCell, 2, 1) <> "", Mid(TargetCell, 2, 1), 0) & Left(TargetCell, 1)
End Function

Excel Formula:
=rever(A1)
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.

Thank you so much!!
 

Watch MrExcel Video

Forum statistics

Threads
1,114,209
Messages
5,546,552
Members
410,746
Latest member
Tcestnick
Top