Copy cells and paste into a merged cell

Is there a way to copy contents from cells in a spreadsheet and paste them into a merged cell on a workbook that I am working on?

Reposting this to see if I can get any help!!

Hello, try something like this:

Sub test()

If Cells(1, 1).MergeCells Then
    Cells(1, 1).MergeArea.Value = Cells(1, 6).Value
Else
    Cells(1, 6).Copy Cells(1, 1)
End If

End Sub

Hi,

Use Concatenate.

If merged cell is AB1 (top left two cells) and values you want are in A2 and B2 then;

in AB1 (merged cell) enter:

=CONCATENATE(A2," ",B2)

Remove ," " if you dont want a space between data