View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo[_2_] Sheeloo[_2_] is offline
external usenet poster
 
Posts: 364
Default Exporting to excel from NotePad

One way is to split your notepad file into two or more as required.

Is 65K the size or number of rows in your notepad file?
You can also copy a part and paste it in Excel and then convert via
Data|Text to Columns...

Excel version? Excel 2007 does not have this limitation.


"Hardeep_kanwar" wrote:

Dear all

I have data that is more than 65k in notepad.Now i want to Export this data
in excel, But when i Export this data it show the message (DATA OVERLOAD).

Is it possible to export data in one sheet1 and remaining data in Sheet2


Any help will be Appriciate

Thanks in Advance