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 |
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 |
All times are GMT +1. The time now is 11:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com