Hello,

Once your macro identifies the first cell (as you say that it can), this line will merge the contents of that cell with the cell one column to the right of it:

MsgBox ActiveCell.Value & " " & ActiveCell.Offset(0, 1).Value

Just change the "MsgBox" part to whatever you need (i.e. a Range value, a variable, etc.)

Ben