Concatenate

[dorothy831]

If I have two columns of information is there a way to concatenate them?

Column 1
101

Column 2
100100

Concatenate to be 101100100


I appreciate any assistance to help make my life a bit easier.

Kindly,

 

[Weaver]

If you have headers, then in C2

=A2 & B2

Then copy the formula down

 

[Harley78]

Well, if your I understand you then you concenate Cell A2 and B2 by formula in C2

=CONCATENATE(A2,B2)

 

[dorothy831]

Boy that was a very quick response and very helpful!

Warm regards,

 

[dorothy831]

ADVERTISEMENT

Another question now, what if I can not have the data from column 1 and cloumn 2 in the spreadsheet once I get the answer in column 3?

Is there a way to convert the formula in column 3?

 

[Harley78]

is the data coming from another worksheet?

Then

=CONCATENATE(Sheet name!+cell,Sheet name!+cell)

another hint,

Press the fx on the formula bar and type in Concatenate and it will walk you through what your trying to do!

 

[lenze]

Is there a way to convert the formula in column 3?

Sure. Select the cells in column "C" and copy. Then use Paste Special>Values

lenze

 

[dorothy831]

I love this site.

Thanks to all of you!