Thanks Jindon for the code. This is working fine for the first row in my spreadsheet. However, for every other row, the resulting csv file starts with a comma. For instance, my original file has 3 rows with 3 columns each:
apple smith 100
pear jones 20
orange jackson 120
After running your code, the resulting csv file has:
"apple","smith","100"
,"pear","jones","20"
,"orange","jackson","120"
The commas that begin rows 2 and 3 are not supposed to be there.
Thanks, Jack
Bookmarks