Maximum Number of Rows - Excel 2010

Hi All!

My question is related to a previous one I posted here, but I'm posting it separately as I can see it being useful for others outside of my context.

http://www.excelforum.com/excel-gene...-in-a-row.html

I'm dealing with a piece of simulation software that spits out millions of data points in the form of a .txt file which forms columns by delimiting them...no problems there Excel deals with that fine.

However I am maxing out the number of rows, is there a way I can increase the maximum row size? Or failing that, can I get it to "cycle" over to the next columns? E.g

Please Login or Register  to view this content.

My other alternative is to split my text file manually, but I'd prefer to avoid anything that I can screw up on and make a mistake with and lose order and/or a chunk of data.

Thoughts and suggestions appreciated!

Cheers,

QP

Thanks, I thought it would be the case, but asked here just in case!

All the best

QP