Sorry, more explaination. What I want to do is read the long string from a text file, split it (as above), use an array to parse each section into cells with each section being on a new row, then read the next record (loop). What I have is more cells than Excel has columns. Hence I need to parse as in field 1 = A1, field 2 = B1, etc. and end up stacking part of the record. Its not pretty but that is the only solution I could come up with.