View Single Post
  #5   Report Post  
Lady Layla
 
Posts: n/a
Default

Open in Excel as csv file, Select Column A, Choose Data Text to Columns --
select , as delimiters


"acyakos" wrote in message
...
: Frank-
:
: When I try to open the file, a text import wizard pops up, however, there
: are a bunch of commas and everything is in one column. I don't want any of
: the commas in there and I want it to be in separate columns. Hopefully this
: is clear...
:
: Thanks for your help!
:
: "Fredrik Wahlgren" wrote:
:
:
: "acyakos" wrote in message
: ...
: I received a file that is saved as a .CSV format. How would I change this
: into the .XLS (normal Excel) format without having all the data jumbled
: up?
:
: How is the data jumbled up? Excel can open csv files.
:
: /Fredrik
:
:
: