merge 2 columns
 

I need to take column E and append it to it's own row in column D,
like this, creating a new column F:

R1CD R1CE R1CF
122 Main St New York 122 Main St, New York

Notice I needed to stick a comma and a space between the fields before
putting them in the new column.

Any help sure would be appreciated.
Thanks
Joanne

merge 2 columns
 

=E2 & ", " & f2

then drag fill down the column.

--
Regards,
Tom Ogilvy


"Joanne" wrote:

I need to take column E and append it to it's own row in column D,
like this, creating a new column F:

R1CD R1CE R1CF
122 Main St New York 122 Main St, New York

Notice I needed to stick a comma and a space between the fields before
putting them in the new column.

Any help sure would be appreciated.
Thanks
Joanne

merge 2 columns
 

sorry
in f2
=D2 & ", " & E2

then drag fill down the column.

--
Regards,
Tom Ogilvy


"Joanne" wrote:

I need to take column E and append it to it's own row in column D,
like this, creating a new column F:

R1CD R1CE R1CF
122 Main St New York 122 Main St, New York

Notice I needed to stick a comma and a space between the fields before
putting them in the new column.

Any help sure would be appreciated.
Thanks
Joanne