I create files on a mainframe that are both fixed-length AND delimited (usually semi-colon) and load them into Excel as .txt. I bring them into Excel as delimited but have to individually adjust COLUMN width. Since I frequently have 20 or more columns, this is tedious. I know there must be a way that Excel can figure out my lengths, but I don't know what am I doing wrong (either in Excel or upload from mainframe). Thanks.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to avoid default Column Width
- Thread starter pfb46
- Start date
energman58
Well-known Member
- Joined
- Oct 25, 2010
- Messages
- 553
Import your data
Select your data (or select everything)
Data - Text to columns - delimited - next
check whatever your delimiters are (semicolons or whatever) in the list or add new ones at the end
Finish
Should do what you want
Select your data (or select everything)
Data - Text to columns - delimited - next
check whatever your delimiters are (semicolons or whatever) in the list or add new ones at the end
Finish
Should do what you want
Upvote
0
energman58
Well-known Member
- Joined
- Oct 25, 2010
- Messages
- 553
Just re-read your question I guess you got the data in OK but the column widths are wrong?
In 2007 you can get Excel to auto format the columns by selecting your data and then in the home tab under cells click format - autofit column width and that shoudl do it
The functionality is there in earlier versions too - I think under Format but I cant quite remember where (amazing 6 months and you forget everything!)
In 2007 you can get Excel to auto format the columns by selecting your data and then in the home tab under cells click format - autofit column width and that shoudl do it
The functionality is there in earlier versions too - I think under Format but I cant quite remember where (amazing 6 months and you forget everything!)
Upvote
0
Similar threads
- Question
