Test.xlsI am trying to put together a macro that will:
1. Merge the contents from two cells together (i.e., C3:C4 merged into C3)
2. Separate the contents with a soft return in the merged cell

The contents or values do not need to be added, as in 1+1 = 2. The values need to remain separate.
I found a method to merge the two cells, but it deletes the contents from the second cell.

Is there a way to merge the two cells, or copy the contents from C4 into C3 and keep the contents separated by a soft return?

Thanks!

Sub merge()
'
' merge Macro
'
    Range("C3:C4").Select
    With Selection
        .HorizontalAlignment = xlCenter
        .Orientation = 0
        .AddIndent = False
        .IndentLevel = 0
        .ShrinkToFit = False
        .ReadingOrder = xlContext
        .MergeCells = False
    End With
    Selection.merge
End Sub