ExcelBanter - how to merge 2 colomns

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how to merge 2 colomns (https://www.excelbanter.com/excel-worksheet-functions/107892-how-merge-2-colomns.html)

Narendra

how to merge 2 colomns

i have two colomns as stated below
how do i merge it?

17 02-Sep
30 02-Sep
13 02-Nov

Carim

how to merge 2 colomns

Hi,

In cell C1, just type
=A1&B1
and copy down ...

HTH
Carim

All times are GMT +1. The time now is 05:15 AM.