Welcome Guest
Log In | Register )
You last visited December 10, 2016, 9:32 am
All times shown are
Eastern Time (GMT-5:00)

Excel help

Topic closed. 7 replies. Last post 2 years ago by SergeM.

Page 1 of 1
PrintE-mailLink
Rakster's avatar - praying hands.jpg
Saskatchewan
Canada
Member #19992
August 9, 2005
2867 Posts
Offline
Posted: April 12, 2015, 12:58 pm - IP Logged

I tried searching this and couldn't find what I was exactly looking for...

I got 3 numbers in 3 seperate columns.... I want to put them all together into 1 column.

Example

|  1 |  2  |  3  |  ----->  |  123  |

Is there a formula for this?  And if so, can it be done for an entire row at one time or individually?

 

Thanks

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

    Raven62's avatar - binary
    New Jersey
    United States
    Member #17843
    June 28, 2005
    49813 Posts
    Online
    Posted: April 12, 2015, 1:05 pm - IP Logged

    I tried searching this and couldn't find what I was exactly looking for...

    I got 3 numbers in 3 seperate columns.... I want to put them all together into 1 column.

    Example

    |  1 |  2  |  3  |  ----->  |  123  |

    Is there a formula for this?  And if so, can it be done for an entire row at one time or individually?

     

    Thanks

    Cell A2=1
    Cell B2=2
    Cell C2=3

    Cell D2: =A2*100+B2*10+C2

    A mind once stretched by a new idea never returns to its original dimensions!

      Rakster's avatar - praying hands.jpg
      Saskatchewan
      Canada
      Member #19992
      August 9, 2005
      2867 Posts
      Offline
      Posted: April 12, 2015, 1:26 pm - IP Logged

      Cell A2=1
      Cell B2=2
      Cell C2=3

      Cell D2: =A2*100+B2*10+C2

      Thank you Raven!!

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

        Avatar

        United States
        Member #41846
        June 23, 2006
        460 Posts
        Online
        Posted: April 12, 2015, 9:22 pm - IP Logged

        Cell A2=1
        Cell B2=2
        Cell C2=3

        Cell D2: =A2*100+B2*10+C2

        Raven and Rackster  another way would be   in D2   =a2 & b2 & c2

          SergeM's avatar - slow icon.png
          Economy class
          Belgium
          Member #123700
          February 27, 2012
          4035 Posts
          Offline
          Posted: April 13, 2015, 10:01 am - IP Logged

           =A:A & B:B & C:C

            Avatar
            GA
            United States
            Member #158157
            August 13, 2014
            99 Posts
            Offline
            Posted: April 14, 2015, 11:48 am - IP Logged

            simply do  =CONCATENATE(A1,"",B1,"",C1)  if your cell are A1 B1 C1. if not adjust accordingly.

              winsumloosesum's avatar - Lottery-060.jpg
              Pennsylvania
              United States
              Member #2218
              September 1, 2003
              5387 Posts
              Offline
              Posted: April 24, 2015, 5:25 pm - IP Logged

              A1= 1

              B1= 2

              C1= 3

              =VALUE(CONCATENATE(A1,B1,C1)

                SergeM's avatar - slow icon.png
                Economy class
                Belgium
                Member #123700
                February 27, 2012
                4035 Posts
                Offline
                Posted: April 24, 2015, 7:02 pm - IP Logged

                A1= 1

                B1= 2

                C1= 3

                =VALUE(CONCATENATE(A1,B1,C1)

                '={"<!--"&(SQRT(MOD(1/2*VALUE(TEXT(VALUE(CONCATENATE(""&A1,""&B1,""&C1)),"000"))*2,1000))^2)&"-->"}