Archiver > GENEALOGY-DNA > 2010-11 > 1290195042

From: Robert Stafford <>
Subject: [DNA] Opening the Results .csv File
Date: Fri, 19 Nov 2010 13:30:42 -0600

For those having problems eliminating the date and hyphens on their
spreadsheets,one solution is to download OpenOffice at Open the .csv file with their spreadsheet and a
delimiter box will open. Add "other -". (The text recognition character
should be the default ".) If you used a hyphen in any of your text, this
procedure will split the two parts, so it is a good idea to change it on the
FTDNA site. The headings will be misaligned. However, once you get them set
up, you can save a copy to paste on any new sheet.

Bob Stafford

This thread: