Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel should allow me to change text color & font within tabs. | Excel Discussion (Misc queries) | |||
Change column Number vrs Text | Excel Worksheet Functions | |||
how do I change the text case of imported data in excel? | Excel Discussion (Misc queries) | |||
change typed text to upper case | Excel Discussion (Misc queries) | |||
How to change text in multiple cells from Uppercase to proper cas. | Excel Worksheet Functions |