Join two columns to create a third

[navota]

I need sm1 to help me here:

I have data in two columns, column 1 & column 2, I wish to join them & show it in column 3. Can anyone help me with this.

Thanks.
Hostmonster 3.95 Bluehost 3.95 Hostmonster 3.95 promo
Bluehost 3.95 promo

[pkon]

Column3

[navota]

Thanks for the quick reply. Where do I put that line? Sorry if that is a very basic question...

[pkon]

You have to make this formula in your column3

So to show A1 + A2 joined you can put this formula into A3.

[navota]

Thanks a lot pkon... it worked