| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting Large Text files to excel
Hi,
I have several text files having more than 65000 rows. The character separating the rows is | (piped character). Can someone help me as to how this can be done. Its all right if the data runs across several sheets for each file. I will really appreciate the help. Warm regards Fari |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Converting Large Text files to excel
Fari,
One solution is to get the new version of Excel, which does not have the 65K row limit. Otherwise Google for "Excel import more than 65000 rows" and you will get a lot of hits. NickHK "fari" wrote in message oups.com... Hi, I have several text files having more than 65000 rows. The character separating the rows is | (piped character). Can someone help me as to how this can be done. Its all right if the data runs across several sheets for each file. I will really appreciate the help. Warm regards Fari |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel (xls) files spontaneously converting to text files | Excel Discussion (Misc queries) | |||
| Converting Large XML Files into CSV File via Excel | Excel Discussion (Misc queries) | |||
| Converting Large XML Files into CSV Files for Excel | Excel Discussion (Misc queries) | |||
| Converting a LARGE volume of numbers to text in Excel for VLOOKUP | Excel Programming | |||
| VBA Excel: Opening Very Large Text Files | Excel Programming | |||
Linear Mode
