Need to make txt sheet with specific fields taking up a specific number of spaces.

@ajca01,

Here's an example that will create a txt file. First save the attatched workbook to your computer. The output of the txt file will be in the same folder as the workbook folder. Without knowing the structure of your Excel file that you are needing manipulated into a text file its hard to make an example. So this should give you an idea, also its only an example of Record Type 1 (Provider Record).

Space Sample_v3.xls

Let me know more of your data structure in your workbook and Im sure I can make your life a little easier.

Thanks Mike