Thanks again to Ann and Jim I was able to get my 23andme data into Excel, sort in ascending order and easily find the snp I was looking for in a list of over 800 lines. According to the folks on thr Hg I list, this tells me I am L840+ and do not need another FTDNA test to find out. Thanks again Ron ________________________________ From: "[email protected]" <[email protected]> To: [email protected] Sent: Thursday, April 5, 2012 3:00:02 AM Subject: AUTOSOMAL-DNA Digest, Vol 2, Issue 56 Today's Topics:   1. Re: AUTOSOMAL-DNA Digest, Vol 2, Issue 54 (Jim Bartlett)   2. Re: AUTOSOMAL-DNA Digest, Vol 2, Issue 54 (Ann Turner) ---------------------------------------------------------------------- Message: 1 Date: Wed, 04 Apr 2012 17:47:59 -0500 From: Jim Bartlett <[email protected]> Subject: Re: [AUTOSOMAL-DNA] AUTOSOMAL-DNA Digest, Vol 2, Issue 54 To: RON SINCLAIR <[email protected]>,     "[email protected]" <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain; charset=us-ascii Ron Copy the list; position your cursor on an Excel cell and paste. Jim - Sent from my iPhone - FaceTime! On Apr 4, 2012, at 4:57 PM, RON SINCLAIR <[email protected]> wrote: > Does anyone know how to get the raw data in the text file form into a spread sheet so that it can be sorted sequentially in order to find a specific SNP? Can it be brought into Excel? The data is my own data. > Appreciate instructions as to how to do it. > Thanks, > Ron > > > ________________________________ > From: "[email protected]" <[email protected]> > To: [email protected] > Sent: Wednesday, April 4, 2012 2:16:35 PM > Subject: AUTOSOMAL-DNA Digest, Vol 2, Issue 54 > > > > Today's Topics: > >    1. extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen) >    2. Re: extracting Y-DNA SNPs from 23andMe ([email protected]) >    3. Re: extracting Y-DNA SNPs from 23andMe (Ann Turner) >    4. Re: extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen) >    5. Re: extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen) >    6. Re: extracting Y-DNA SNPs from 23andMe (Larry Vick) >    7. Re: extracting Y-DNA SNPs from 23andMe (Ann Turner) >    8. Re: extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen) >    9. Re: extracting Y-DNA SNPs from 23andMe (Diana Gale Matthiesen) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 4 Apr 2012 08:58:14 -0400 > From: "Diana Gale Matthiesen" <[email protected]> > Subject: [AUTOSOMAL-DNA] extracting Y-DNA SNPs from 23andMe > To: <[email protected]> > Message-ID: <[email protected]> ------------------------------ Message: 2 Date: Wed, 4 Apr 2012 16:05:55 -0700 From: Ann Turner <[email protected]> Subject: Re: [AUTOSOMAL-DNA] AUTOSOMAL-DNA Digest, Vol 2, Issue 54 To: RON SINCLAIR <[email protected]>, [email protected] Message-ID:     <[email protected]om> Content-Type: text/plain; charset=ISO-8859-1 Open Excel first, then use the File | Open dialog and locate the file. Double click on the file name to open. It is a tab-delimited file, which Excel knows how to handle.  You must have Excel 2007 or higher because of the large file size. Ann Turner On Wed, Apr 4, 2012 at 2:57 PM, RON SINCLAIR <[email protected]>wrote: > Does anyone know how to get the raw data in the text file form into a > spread sheet so that it can be sorted sequentially in order to find a > specific SNP? Can it be brought into Excel? The data is my own data. > Appreciate instructions as to how to do it. > Thanks, > Ron > ------------------------------ End of AUTOSOMAL-DNA Digest, Vol 2, Issue 56 ********************************************