I've several spreadsheets which need to be saved as CSV files ready for being input elsewhere.
I copy the worksheet to a new book, either Save As or Export as CSV with a new name.
If I then open in up in Notepad, there are lots of commas at the end of each line which are nothing to do with the records. For example:
Notes is the last column, there shouldn't be all those commas at the end.
I've tried deleting and hiding the unwanted columns and it's worked on some files and not on others. It seems a bit hit and miss.