When rolling your own csv files, you have to account for commas in the text. Extra commas will create extra columns and you don't want that. Let's start with this data: Two of the names have commas and two don't. By ignoring those commas, extra columns are created because a comma delimits a [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2008/10/17/handling-delimeters-in-csv-files/
Posted
Oct 17 2008, 05:01 PM
by
Daily Dose of Excel