Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All
I have a fixed width text file which contains three columns of data and up to 150,000 rows I wish to read these into a worksheet, parsing the text into three columns (by specifying each column width), putting the data into columns A:C until I reach 50,000. Then loading the next 50,000 rows into columns C:E, the next F:H etc., until all rows have been loaded. Any help greatly appreciated. Cheers Nigel ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Controlling text in an Excel worksheet | Excel Worksheet Functions | |||
Controlling VBA | Excel Programming | |||
Controlling the position of attachments and Body Text in Outlook | Excel Programming | |||
controlling date entry in a text box | Excel Programming | |||
Loading text file | Excel Programming |