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
|