GENEALOGY-DNA-L Archives

Archiver > GENEALOGY-DNA > 2010-11 > 1289746400


From: Robert Stafford <>
Subject: Re: [DNA] New FTDNA Project Format
Date: Sun, 14 Nov 2010 08:53:20 -0600
References: <BFECJOAEEPCFBFFLLBGPGEFJHJAA.dna@irishtype3dna.org><B0A97FB027D64C6AB00E3AEF55659BDF@julief20dec08><000e01cb83fd$2b6e3b00$824ab100$@dgmweb.net><215A1197496C4648B69F2A2FED6FCE24@elizabethod>
In-Reply-To: <215A1197496C4648B69F2A2FED6FCE24@elizabethod>


It is just a little more trouble to convert to Excel. I did it from the
public pages. Click on the left corner of the spreadsheet and change
universal cell format to text. Select all and copy FTDNA table. Paste to
spreadsheet. Select destination formatting from the bug at the bottom.
Delete extraneous matter. Insert the extra columns needed next to the
multicopy markers. From data, select text to columns with "-" as delimiter.
Change universal format back to general.

When adding data to a spreadsheet, you simply reformat the data on a new
spreadsheet first, but often it is easier to copy results already on the
spreadsheet and correct a few markers.

Bob Stafford


This thread: