i have around 2.5 million rows of 5 numbers in a text file.
i would like to transfer them to an excel document. as the sheet is only 65536 rows down, it would take up more than one sheet (or more columns on the same sheet).
i tried a macro to cut the lines and paste them from notepad to excel, putting them in a new worksheet tab when one filled up. however i calculated it would take 5-6 hours to do every line.
each line contains 5 numbers. each number represents a playing card 1-52. i am trying to generate all 2.5 million possible hands of 5 card poker.
my question is, could i come up with a formula to do this without cutting from a txt file?
eg row one = 1,2,3,4,5
row two = 1,2,3,4,6
row three = 1,2,3,4,7
etc
i have tried 5 formulae, one for each cell across, but it keeps going wrong.
any ideas?
i would like to transfer them to an excel document. as the sheet is only 65536 rows down, it would take up more than one sheet (or more columns on the same sheet).
i tried a macro to cut the lines and paste them from notepad to excel, putting them in a new worksheet tab when one filled up. however i calculated it would take 5-6 hours to do every line.
each line contains 5 numbers. each number represents a playing card 1-52. i am trying to generate all 2.5 million possible hands of 5 card poker.
my question is, could i come up with a formula to do this without cutting from a txt file?
eg row one = 1,2,3,4,5
row two = 1,2,3,4,6
row three = 1,2,3,4,7
etc
i have tried 5 formulae, one for each cell across, but it keeps going wrong.
any ideas?