Importing CSV FIles

B

BrooksRx

Does anyone know if there is a way to force Excel to
expand columns to the maximun width needed when opening
a .CSV file? I am looking to minimize user input.
 
M

Mona

CSV is a text format. When u import txt. file, first "save as" Excel format. After that open the workbook again(now in excel format). Go to "data" menu use "text to columns" tab. Yr data would be converted to columns.
 
B

BrooksRx

-----Original Message-----
CSV is a text format. When u import txt. file,
Click to expand...
first "save as" Excel format. After that open the workbook
again(now in excel format). Go to "data" menu use "text to
columns" tab. Yr data would be converted to columns.
.
The application creating the file can only save as csv
Click to expand...
format. It then emails it as an attachment to the user,
and when they launch it, Excel opens the file. But all
the columns are too small to display the header. I was
trying to find a way to automatically expand the column
upon file open. Any ideas would be appreciated.
 
D

Dave Peterson

But .csv files won't have any macros--they're just plain text.

I like your answer or just Ctrl-A and double clicking on a column separator in
the column headings.
 
Top