Cell Value to be copied to upper cell

Assume I have a Value in Cell A1 & A2 (A1 = 123 & A2 = ABC)

I want to write a code where I can Copy the contents of cell A2 and concatenate it with cell A1 with a space in between.

For example if I run the macro considering the above example, my output in cell A1 should be 123 ABC.

Here A1 & A2 were examples. These cells can be anywhere on the sheet. But the offset will always remain of 1 row between both cells.

Can anyone suggest a way I can do that?

Hello,

Give this a try:

Please Login or Register  to view this content.

It will concatenate whatever cell you have currently selected. Cheers.

Steve

Perfect.

Marking the thread as solved!