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
Last Modified On:
No, open a new Support Case