Hi,

Is there an easy way to concatenate two cells??

Suppose the worksheet has six cells like this:

Row 1: John Smith
Row 2: Dick Jones
Row 3: Property Acme

Rows one and two are the way they should be, but row three should read `Acme
Property' in the right hand cell, while the left hand cell should be empty.

Is there a way to automate this process on a large worksheet without
retyping all the data??

Thanks,

Sam