Hey guys,

I know that I can do this the hard way, but am wondering if there is an easier way to do it.

I need to create a text file of data for upload into my system. The deal is, though, that it needs to be in a text file, and it has to have its data in certain places as shown following (forgive the crude indenting):
Position Length Data required

1 - 6 - Date (MMDDYY)
7 - 10 - Member Number (left justified)
17 - 30 - Member Name (left justified)
47 - 1 - Not Used
48 - 10 - Check Number (right justified)
58 - 10 - Check Amount (leading zeros-implied decimal)
68 - 13 - Not Used
Some right aligned, some left aligned, etc.. Now I know I could build a string for an entire line, then dump it in one at a time, but this seems like overkill. Is there an easier way to build it in Excel and save it to the correct format with specified string lengths in the txt file output?