MS Excel: Fixed Width File Tool

In my line of work I frequently have to manipulate data which comes to me in a variety of different formats. One relatively common format is the "Fixed Width File". Getting such data into Excel using its wizard can be a rather tiresome affair, so I created this little workbook, containing a few simple macros, to make the job easier.


Simply copy the content of the fixed width file into the first column of the "input" worksheet, give a specification of the field lengths in the "Specification" worksheet, and then click a button. The workbook does the rest for you, and you can copy the resulting data into another workbook as required.