Use the following Excel sample to merge two columns into a third column:
Sub Macro1()

Dim lctemp As String

'Concatenate Columns 1 and 2 to column 3
Range(Sheet1.Cells(2, 3), Sheet1.Cells(2, 3)).Value = Range(Sheet1.Cells(2, 1), Sheet1.Cells(2, 1)).Value  & Range(Sheet1.Cells(2, 2), Sheet1.Cells(2, 2)).Value

End Sub

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: December 10, 2016