Creating a text file from Excel

GlennG · May 21st, 2002, 07:35 PM

Hello,

Is it possible to create a text file from an Excel file that would have the equivalent of 1200 cells of information on each line ?

I can only create a text file with 256 cells in width.

Any ideas ?

stevebausch · May 21st, 2002, 08:23 PM

You can copy and paste into Notepad. I don't know about the total size of the file, however.

Yogi Anand · May 21st, 2002, 09:34 PM

Quote:

On 2002-05-21 18:35, GlennG wrote:
Hello,

Is it possible to create a text file from an Excel file that would have the equivalent of 1200 cells of information on each line ?

I can only create a text file with 256 cells in width.

Any ideas ?

Regarding first part of your question -- yes!it is possible to create a text file from an Excel worksheet. In regard to other parts of your question, I do not understand what you are looking for -- however in using Excel 97, I can use upto a maximum of 32767 alpha-numeric characters in a cell.

Regards!

PDuPre' · May 21st, 2002, 09:43 PM

If you are trying to create a comma delimited file perhaps you can build on the post above and simply have the contents of some cells be formatted to fit your file.

anno · May 22nd, 2002, 12:21 AM

i think glenng's problem arises from excel's 256 column limit - he's looking for a 1200 column spreadsheet to do what he wants (btw is xp still limited to 256 columns?)

one way i can think to get around this - if it's going into a text file, why not concatenate your 1200 entries into 256 cells (i admit this will take a bit of effort), do a copy>paste special>transpose to get the information in rows, and then copy to a text file. does that make sense?

the only other thing i can suggest is to select 256 rows at a time, copy>paste special>transpose and then copy to your text file.

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

May 21st, 2002, 07:35 PM	#1
GlennG Board Regular Join Date: May 2002 Location: Montreal, Canada Posts: 80	Hello, Is it possible to create a text file from an Excel file that would have the equivalent of 1200 cells of information on each line ? I can only create a text file with 256 cells in width. Any ideas ?

May 21st, 2002, 08:23 PM	#2
stevebausch Board Regular Join Date: May 2002 Posts: 809	You can copy and paste into Notepad. I don't know about the total size of the file, however.

May 21st, 2002, 09:43 PM	#4
PDuPre' Board Regular Join Date: Apr 2002 Location: Trussville, AL Posts: 134	If you are trying to create a comma delimited file perhaps you can build on the post above and simply have the contents of some cells be formatted to fit your file.

May 22nd, 2002, 12:21 AM	#5
anno Board Regular Join Date: Feb 2002 Posts: 202	i think glenng's problem arises from excel's 256 column limit - he's looking for a 1200 column spreadsheet to do what he wants (btw is xp still limited to 256 columns?) one way i can think to get around this - if it's going into a text file, why not concatenate your 1200 entries into 256 cells (i admit this will take a bit of effort), do a copy>paste special>transpose to get the information in rows, and then copy to a text file. does that make sense? the only other thing i can suggest is to select 256 rows at a time, copy>paste special>transpose and then copy to your text file.