How to split a text file into two worksheets?

karraj · Apr 9th, 2002, 07:42 AM

I have a comma seperated file with more than 256 columns, I want to seperate it into two spreadsheets. Any suggestions for that.
Thanks in advance.
Karraj

Al Chara · Apr 9th, 2002, 07:45 AM

You can try downloading:
http://asap-utilities.com/
They have a lot of helpful tools. They have one where you can import a comma separated text file. But I don't know how they will handle one with 256 columns. Worth a try though.

Apr 9th, 2002, 07:45 AM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	You can try downloading: http://asap-utilities.com/ They have a lot of helpful tools. They have one where you can import a comma separated text file. But I don't know how they will handle one with 256 columns. Worth a try though. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 07:42 AM	#1
karraj Board Regular Join Date: Mar 2002 Posts: 76	I have a comma seperated file with more than 256 columns, I want to seperate it into two spreadsheets. Any suggestions for that. Thanks in advance. Karraj