Txt file in Excel

[adeel1]

Hello All

i have a text file there is 5.6Million numbers in it, only will come in column A in excel, is there any way to upload in excel 10M in each sheet!

data in text file is look like below.

Capture.PNG

Adeel

[HansV]

A worksheet in an Excel workbook in a recent format (.xlsx, .xlsb or .xlsm) has 1048576 rows. There is no way to change that.
You can, of course, write the first million rows to column A, then the next million rows to column B, etc.

[adeel1]

does this possible with code as you suggested

Adeel

[HansV]

See for example Importing Large Files In To Excel

[adeel1]

thnx sir , its work

Adeel