Thank you!
The file did have a .csv extension, but it wasn't being honored, apparently.
However your "Text to columns" suggestion worked great.
"Lady Layla" wrote in message
...
Laurel
Comma delimited Text file and .csv files are one and the same.
Find the file you downloaded, either change the extension to .csv or .txt
if it
is neither.
If you cant, then once the information is in Excel, select the column of
data,
and in your Tool bars -- Select Data, Text to columns, make sure the comma
box
is checked and you will have neat columns agaian.
"Laurel" wrote in message
...
: My credit card company has an export feature. One of the options is
".csv
: (Excel). This used to give me a nice clean spreadsheet with each column
of
: information in a separate Excell column. I guess it converted on the
fly or
: something. But now it seems to be a "comma delimited text file" In
other
: words, only the first Excel cell in each row has data in it, and it
looks
: like this in each row (the first row has headings).
: 1,"03/24/2005","HARVARD CS","Credit","$39.95". What can I do to get
all
: those comma delimited items into separate cells?
: I've tried contacting the Credit Card company to no avail. Is the fact
that
: the first item is not enclosed in quotes significant?
:
: This is actually a repost, as I tried to pursue this when I first
discovered
: it with last month's statement, but didn't get answers that provided a
: solution.
:
:
|