Just read some posts. I don't want to do the macro as see it recommended a
lot for over 65,000 rows.

How can I cut the .txt file in 2? I have no issue with having 2 separate
Excel files.

The copy/paste copy/delete not working in Notepad.
--
Paul


"QuestionMan" wrote:

Hi,

For Excel (2000) trying to import an .txt/notepad file. It's large (25mb)

Only half the file (65,000 names/address, etc) is downloading, than get error
message. And excel sheet stops at 65,000 and rest is all gray. So not sure
if imported and can't see.

What is the limit to import into Excel?

I have tried to cut the .txt file in half and have 2 .txt files and 2 excel
files to minimize size but difficult to copy/paste or copy/edit in Notepad.
These functions don't work as well as they do in Word or Excel.

Suggestions?

Thanks.
--
Paul