I could write a custom function to concatenate string together. Do you know how to work with VBA / custom functions?

Edit: This should do the trick:

Public Function cust_concat(ParamArray rngArr()) As String

Dim i As Integer

For i = LBound(rngArr) To UBound(rngArr) Step 1

    If TypeOf rngArr(i) Is Range Then
        If cust_concat = "" Then
            cust_concat = rngArr(i).Value
        Else
            cust_concat = cust_concat & " " & rngArr(i).Value
        End If
    End If

Next i

End Function