Excel should warn about commas when saving .csv files.
Using Excel 2003 or previous version.
When a worksheet with any number of cells containing numbers and/or text including the comma ',' character is saved as a *.csv (Comma Delimited file), there should be a warning or alert notifying the user. This alert should give the choice of continuing to save the file, or going back and removing the commas or replacing them with a different character. This alert should give a brief description of the consequences of keeping the commas (ie. they will be interpreted as an extra field when the file is reopened.) ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Excel should warn about commas when saving .csv files.
Excel will put double quotes around fields with embedded commas.
If you open a CSV file, excel will be smart enough to know that you're in one field. Are you experiencing something else? What version of excel are you using? hydroEng wrote: Using Excel 2003 or previous version. When a worksheet with any number of cells containing numbers and/or text including the comma ',' character is saved as a *.csv (Comma Delimited file), there should be a warning or alert notifying the user. This alert should give the choice of continuing to save the file, or going back and removing the commas or replacing them with a different character. This alert should give a brief description of the consequences of keeping the commas (ie. they will be interpreted as an extra field when the file is reopened.) ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc -- Dave Peterson |
All times are GMT +1. The time now is 06:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com