Excel should warn about commas when saving .csv files.

[Guest]

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/com...f-b05b2990bd10&dg=microsoft.public.excel.misc

 

[Dave Peterson]

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?