Undesired automatic parsing of .csv files

D

dbsavoy

I think this is a bug in Excel, but I need some expert opinions to be sure.

I often need to download files in .csv format from an intranet site at my
company. When I open these files, Excel automatically parses the data into
fixed width columns. However, for example, Excel may parse data into fixed
width columns for Col A - G, then leave the lengthy remainder of the data
string in Col H.

I have checked that a comma is used as the List separator in the Regional
and Lanugage options. And none of my coworkers experience this problem.

Any advice would be appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

.csv Commas ? 2
csv files do not parse and open up like they should 0
Turn Off automatic parsing of data in Excel 1
CSV File Opening Conversion Issue 1
Excel VBA macro to auto import new CSV file from fixed directory 1
Parse a txt file and save as csv? 4
Fixed width 4
Open a .csv file, parse text and display on more than one sheet 3

Top