[thelist] Stupid Hack in Winblowz for CSV Delimiters
Chris Dorer
cdorer at gmail.com
Thu Mar 1 11:09:55 CST 2007
Don't tell me this, seriously, Joel ;).
I fumbled with the 'text to columns' under 'data' for 3 hours to no avail.
I was trying to use the pipe '|' as a delimiter
On 3/1/07, Joel D Canfield <joel at streamliine.com> wrote:
>
> > 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
> --
>
> * * Please support the community that supports you. * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>
More information about the thelist
mailing list