Joining Two Columns

K

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
 
P

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
 
Top