This question is much like Charlie's Mom, with one difference which may be
important. I have a stacked address file (created by an old DOS based
program)that was pasted into Word 97, and had delimiters changed to ones that
Word could recognize. There is one record delimiter for the name, and one
field delimiter for 3 lines of addresses. When I try to sort on the name
field in a mail merge, nothing changes. I think it is because of the
delimiter in front of the name. Can I import this file into Excel, with the
names and corresponding addresses unstacked, i.e. Names in column 1,
addresses in column2, column 3, etc.? So far, everything I do just stacks
them in Excel, with the delimiters showing. Does the record and field
delimiters that I chose make a diffence to Excel? PS. I can live with the
address fields being stacked in one column in Excel, but without the
delimiters showing.) Thank you for any help you can give me.
--
sharon