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:
You don't have the appropriate permissions.
No, open a new Support Case