Hello,
The problem I've got it when saving a worksheet with 7 rows of data as a CSV, and then opening in a notepad editor, it adds commas at the end of the rows.
I realise what it is trying to do - creating null values (i.e. , , , , , , etc) so that null values make each row equal in length as the longest row (so that there is an equal array/matrix).
Is there any way to save the worksheet so that it doesn't do this and/or is there a delimiting function that can be put at the end of each row.
Any help much appreciated!
Thanks
Bookmarks