Combine two columns and put comma between numbers

[abberyfarm]

Hello,

I don't know if this is even possible in excel.

I have two columns of numbers. Would someone have a macro to merge the two columns into one and put a comma between the numbers?

Or else paste the numbers into a new column? Either way is fine.

A  B  C
1  2  1,2
3  4  3,4
5  6  5,6
7  8  7,8

Thank you

 

[VoG]

Try

Sub iJoin()
Dim LR As Long, i As Long
LR = Range("A" & Rows.Count).End(xlUp).Row
For i = 1 To LR
    Range("C" & i).Value = Join(Application.Transpose(Application.Transpose(Range("A" & i).Resize(, 2))), ",")
Next i
End Sub

 

[abberyfarm]

Thank you