[thelist] Stupid Hack in Winblowz for CSV Delimiters

Joel D Canfield joel at streamliine.com
Thu Mar 1 11:02:03 CST 2007


> So you can no longer open a new Excel Worksheet, and do Data -> Get
> External Data -> Import Text File... ?
> 
> Or rename your CSV file TXT and open it in Excel the normal way?
> (Rename because if your values aren't separated by commas, it
> shouldn't be a CSV.  I'm sure there's a clue there somewhere!)
> 
> I don't know, I don't have Excel 2003.  Have they really removed these
> two methods?

both still exist and work fine (Excel 2003 on WinXP)

also, the 'text to columns' under 'data' allows you to choose a
delimiter on the fly, as it always has. not sure what Chris was trying
to accomplish, but it seems like there might have been an easier way.

joel



More information about the thelist mailing list