Concatenating Data

Hi Freddie

Here's one way of concatinating using vba.
It includes Activecell.Offset(r,c)
where r is the row and c the column position relative to the activecell.

Sub Join()

Range("A2").Select
Do Until ActiveCell = ""
ActiveCell.Offset(0, 2)=ActiveCell & " " & ActiveCell.Offset(0, 1)
ActiveCell.Offset(1, 0).Select
Loop

End Sub

Note
If you want to do the same thing without a macro type
=A2 & " " & B2
into cell C2 and double click the autofill handle.

Hope that works for your data.

Regards
Doug
Best STL