or even easier you can do this: =A1&";"&B1&";"&C1