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:

Please Login or Register  to view this content.

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