Importing text files to Excel, Adjust Column Width not giving the expected results

**billfinnjr** · 06-11-2018, 02:23 PM

I'm importing a fixed width text file into Excel. I am experiencing issues with having the correct column width when the data gets imported. I have been using the Text Import Wizard. The file is very large and it takes a fair amount of clicking to get to a price field to set the proper widths for the 4 price columns. I thought that checking Adjust Column Width in the Properties tab might make this more efficient but it still leaves fragments of a price in the wrong field for prices over $999.99. Any input will be gratefully considered.
Thanks much,
Bill

**alansidman** · 06-11-2018, 02:38 PM

Usually, if you highlight all the columns and then move your cursor to the right upper margin of the last column in the column designation (A, B, C etc.) and double click it will automatically set the width of the columns to as wide as necessary.

**FDibbins** · 06-11-2018, 02:41 PM

You can do Alan's suggestion also if you highlight multiple columns

Importing text files to Excel, Adjust Column Width not giving the expected results

LinkBack

Thread Tools

Rate This Thread

Display

Importing text files to Excel, Adjust Column Width not giving the expected results

Re: Importing text files to Excel, Adjust Column Width not giving the expected results

Re: Importing text files to Excel, Adjust Column Width not giving the expected results

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] split formula of data not giving expected results need assistance

[SOLVED] assistance required copy macro not giving expected results to new sheet

[SOLVED] IMPORTING TEXT FILES TO EXCEL - Multiple Multi-line text files, each in a new column

Automatically adjust column width to fit text? (Pivot)

IF Formula not giving expected results.

Sumproduct formula not giving expected results

Basic Q: Field/Array info when importing fixed-width text files

Bookmarks

Bookmarks

Posting Permissions