Welcome Guest
Log In | Register )
You last visited December 4, 2016, 7:21 pm
All times shown are
Eastern Time (GMT-5:00)

Excel Formula Needed

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

Page 1 of 1
PrintE-mailLink
Rakster's avatar - praying hands.jpg
Saskatchewan
Canada
Member #19992
August 9, 2005
2867 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!

    Avatar
    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!

      Rakster's avatar - praying hands.jpg
      Saskatchewan
      Canada
      Member #19992
      August 9, 2005
      2867 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!

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

        No problem, glad to help!