I've got a bunch of 50MB text files (that I have to segment because of Excel's 65k limit), which I want to import into Excel and convert their data in to columns. All of the files have the same format ...
Each Microsoft Excel worksheet is broken up into cells. Each cell is part of a column. Excel's myriad formatting tools let you add colors, formulas and borders almost anywhere in a worksheet. You can ...