Thread: merge 2 columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joanne[_4_] Joanne[_4_] is offline
external usenet poster
 
Posts: 29
Default 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