What's the most efficient way to disable saving of fields with commas in an entire Excel file? One approach could be to use Data Validation, and the other could be to validate all fields using a macro when the file is being saved. Are there other ways? Which one is better and why?
Do a global search and replace for commas before you save the file. If I am working on address data I just replace the comma with two spaces.