Joining Two Columns

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
--
Kartal

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

HTH
--
AP

"Kartal" <[email protected]> a écrit dans le message de news:
[email protected]...
> 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
> --
> Kartal
>

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

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

"Pete_UK" <[email protected]>, haber iletisinde sunlari
yazdi:[email protected]...
> 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
>

Thanks for the feedback.

Pete