LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
:
:
:




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
can i save an existing .xls file as a .csv file using command line craigkan Excel Discussion (Misc queries) 2 February 18th 05 02:01 PM
When converting an .xls file to .csv I get too many commas at the. One-eyed-Ian Excel Discussion (Misc queries) 3 December 7th 04 12:03 AM
How do I create a .csv file? Anna @ Drohan Co. Excel Worksheet Functions 1 November 16th 04 06:13 PM
.CSV file format - comma or semi-colon? bavjean Excel Worksheet Functions 5 November 12th 04 12:26 PM
.CSV file format - comma or semi-colon antifashionpimp Excel Worksheet Functions 1 November 10th 04 01:18 PM


All times are GMT +1. The time now is 02:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"