Joining Two Columns

[Ardus Petus]

In C1, enter:
=A1&B1
then copy down

HTH

 

[Kartal]

Hi All;
I have two columns. In one them there are only integer values, in the second
one there are alpha-numeric characters. I want to join them in one column.
How can I do that? Thanks.
(For instance a1=12, b1=try15, c1 must be 12try15
a2=34, b2=try35, c2 must be 34try35
....
an
(My columns are too long to join cells one by one)
Regards

 

[Pete_UK]

In C1, enter this formula:

=A1&B1

then copy this down column C. The quickest way to do this is to
double-click the fill handle when the cell is selected (the small black
square in the bottom right hand corner of the cursor).

Hope this helps.

Pete

 

[Kartal]

Thanks both of you, that is just what I wanted.
Regards

 

[Pete_UK]

Thanks for the feedback.

Pete