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.