B
BigBuck98
I have a spreadsheet in Excel 97 that I have 430 names with addresses, etc.
I would like to create a mail merge to a word document, but before I do that
I would like to consolidate some of the names.
I have some names such as John, Joe and Dick all with the same last name and
the same address. They are brothers. Is there any way that I can merge the
first name of these three or four or two what ever the case may be into one
cell and at the same time put a comma between each name?
What I am trying to do is just send one letter to the three of them rather
than three letters. I hope that it is clear what I am trying to do.
Thanks for the help.
Gordon
I would like to create a mail merge to a word document, but before I do that
I would like to consolidate some of the names.
I have some names such as John, Joe and Dick all with the same last name and
the same address. They are brothers. Is there any way that I can merge the
first name of these three or four or two what ever the case may be into one
cell and at the same time put a comma between each name?
What I am trying to do is just send one letter to the three of them rather
than three letters. I hope that it is clear what I am trying to do.
Thanks for the help.
Gordon