Archiver > GENEALOGY-DNA > 2010-11 > 1289768246

From: Mark Jost <>
Subject: Re: [DNA] New FTDNA Project Format
Date: Sun, 14 Nov 2010 14:57:26 -0600

Thats a great method. It appears to solve the data converting to a date and
save a few steps on each MC column. Thanks for mentioning Michael's post.


Message: 10
Date: Sun, 14 Nov 2010 13:51:24 -0600
From: Robert Stafford <>
Subject: Re: [DNA] New FTDNA Project Format
Content-Type: text/plain; charset=ISO-8859-1


See Michael L. H?bert's post about importing the table directly with Excel
2003-2010. You only have to import the results table and no junk. It has an
option to turn off the date recognition.

You then insert the extra columns for multi-copy markers and use text to
columns with "-" as the delimiter from the data menu. You can do a whole
column at once.

Bob Stafford

On Sun, Nov 14, 2010 at 12:53 PM, Mark Jost <> wrote:

> As the amateur I am, I have been playing around with a workaround method
> assist converting Multi-Copy (MC) markers concatenated to decatenate
> spreadsheet columns that are displaying both actual hyphenated markers and
> when some of those same type MC markers that appear as real Calendar Dates
> f


To contact the GENEALOGY-DNA list administrator, send an email to

To post a message to the GENEALOGY-DNA mailing list, send an email to

To unsubscribe from the list, please send an email to

with the word "unsubscribe" without the quotes in the subject and the body
of the
email with no additional text.

End of GENEALOGY-DNA Digest, Vol 5, Issue 873

This thread: