Welcome Guest
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
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!

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!

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!

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

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

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.

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)

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)&"-->"}

 Page 1 of 1