I found some coding and tried to modify it for myself...

but I am getting the a 1004 error. obviously I am big noob and got some parameters wrong.

 Range("B2", Cells(Rows.Count, "C").End(xlUp)).Offset(, 1).FormulaR1C1 = "=CONCATENATE(RC[1],"" "",RC[3],"" "",RC[2]))"
Does anybody know how to alter it to my situation?