Home |
Search |
Today's Posts |
#5
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
can i save an existing .xls file as a .csv file using command line | Excel Discussion (Misc queries) | |||
When converting an .xls file to .csv I get too many commas at the. | Excel Discussion (Misc queries) | |||
How do I create a .csv file? | Excel Worksheet Functions | |||
.CSV file format - comma or semi-colon? | Excel Worksheet Functions | |||
.CSV file format - comma or semi-colon | Excel Worksheet Functions |