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

"Sam" wrote:

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

or if you do not want to use a macro the & symbol will join 2 or more cells


Row 1: John Smith
Row 2: Dick Jones
Row 3: Property Acme
row 4 :=b3 & " " & a3