You could use a macro and write code and have complete control over what you
write.
Here are three sites that you could steal some code from:
Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly:
http://www.smokeylake.com/excel/text_write_program.htm)
Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm
J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html
Earl's program may work right out of the box.
C Brandt wrote:
I have to import data to a system that wants text input.
Up to now I have generated the necessary character strings in column a of a
standard spreadsheet, copied column A then pasted it into notepad and saved
as .txt.
This works just fine but requires several steps. I would like to simply save
it as .txt from Excel, but Excel adds quote (") marks around each entry.
Is there a way to do this so the quote marks are not added to the character
string. I would like to do this with a MACRO.
Thanks,
Craig
--
Dave Peterson