Jane, This is more likely a problem with your database program's export to excel function, unfortunately. If you have the option to export to CSV (comma separated values) I'd try doing that, seeing if the column A information is kept, and then open that file in excel. Which database program do you use? good luck. Brenna On Wed, Feb 10, 2016 at 10:10 AM, Jane McGary <janemcgary@earthlink.net> wrote: > Hi all, > I hope there is someone reading this who is expert in using Excel. I use a > different database program, but from time to time I supply membership lists > to the treasurer and BX manager in Excel. When I export the records to > Excel, there is a problem. The members' surnames appear in Column A, and > the first names in Column B. When two members have the same surname, Excel > drops the second record. This doesn't happen when I export the records to > rtf or Word. Is there a way of making Excel accept records with identical > data in Column A? > > Thanks in advance, > Jane McGary > Membership Coordcinator, PBS > _______________________________________________ > pbs mailing list > pbs@lists.ibiblio.org > http://pacificbulbsociety.org/list.php > http://pacificbulbsociety.org/pbswiki/ >