Welcome Guest
You last visited April 20, 2018, 4:11 pm
All times shown are
Eastern Time (GMT-5:00)

# Excel Formula Needed

Topic closed. 3 replies. Last post 9 years ago by Texas MadMan.

 Page 1 of 1
Member #19992
August 9, 2005
2892 Posts
Offline
 Posted: March 10, 2009, 11:12 pm - IP Logged

I want to get a formula that will post a pair the opposite of itself in a single cell.

Example... if my pair was 1-5, I want a formula that would still pair the numbers up but to show as 5-1 in the same cell.  Does anyone know how to do this?

We are all Lucky... just some of us don't realize it!

New Mexico
United States
Member #58526
February 18, 2008
683 Posts
Offline
 Posted: March 10, 2009, 11:37 pm - IP Logged

Not sure if this is what you're looking for, but if your 1-5 was in say cell A1 and you wanted the 5-1 in cell B1 then you could enter this formula in cell B1:

=mid(A1, 3,1)&" - "&mid(A1,1,1)

this just tells it to look in cell A1 and retrieve the contents starting with the third character (which would be the 5), then add a " - " , then retrieve the contents of A1 starting with the first character (which would be the 1)

should pop up a "5 - 1" in cell B1

hope this helps!

Member #19992
August 9, 2005
2892 Posts
Offline
 Posted: March 10, 2009, 11:52 pm - IP Logged

Not sure if this is what you're looking for, but if your 1-5 was in say cell A1 and you wanted the 5-1 in cell B1 then you could enter this formula in cell B1:

=mid(A1, 3,1)&" - "&mid(A1,1,1)

this just tells it to look in cell A1 and retrieve the contents starting with the third character (which would be the 5), then add a " - " , then retrieve the contents of A1 starting with the first character (which would be the 1)

should pop up a "5 - 1" in cell B1

hope this helps!

Thats exactly what I am looking for.. thanks bud!

We are all Lucky... just some of us don't realize it!

New Mexico
United States
Member #58526
February 18, 2008
683 Posts
Offline
 Posted: March 10, 2009, 11:54 pm - IP Logged