LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Bill Foster
 
Posts: n/a
Default "s Appear in files saved as Text (MS-Dos)

I have an Excel file in which various data manipulations are made on several
worksheets and I end with all the data from multiple columns being
concatenated together in column A on a final worksheet.

I then save this worksheet as a text file in order to upload it into another
program.

However, in some rows double quotes are added. These double quotes are not
visible in Excel, but they do cause my upload to fail. I can see them, and
edit them out, through a text editor like Notepad. But where do they come
from? How can I avoid them alltogether.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text to Columns in excel for delimited files - allow trimming opt. D. Young New Users to Excel 1 April 25th 05 05:06 PM
how do I convert files saved in Corel Quattro Pro 8 into Excel fo. EngineerGirl Excel Discussion (Misc queries) 1 April 16th 05 08:47 PM
unable to reopen saved files message says corrupted conniefrp Excel Discussion (Misc queries) 2 April 11th 05 02:51 AM
Importing text files into Excel Christopher Anderson Excel Discussion (Misc queries) 2 December 4th 04 05:57 PM
mirror saved files excels Excel Discussion (Misc queries) 1 December 3rd 04 06:31 AM


All times are GMT +1. The time now is 09:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"