Separate columns in CSV file

[edmac]

I have a CSV file with columns separated with commas(,)but I want to have all columns separated as in any regular Excel file, how can I do this?

Thanks.

 

[xlhelp]

I take it you want a regular XL file from a CSV file.

In that case simple, open in Excel go to save as and save as an XLS file.

Member- AAAA Association Against Acronym Abusers

 

[SkipVought]

Hi,

...and I want my water to be DRY. How can I do THAT?

A CSV file is a...

Comma
Separated
Values

file.

How can a CSV be anything else? If you change that format, it ceases to be a CSV file.

If you IMPORT the CSV into a workbook and SaveAs an XLS, then it become a WORKBOOK and it ceases to be a CSV file.

Skip,

_[red][/red]

 

[c2rich]

Dear "I have a CSV file"

right click on the .csv, open with and select Microsoft Excel


-Kerry

Those that know, do. Those that understand, teach. -Aristotle