Hi All,
Hoping someone might have a quick solution to the following:
I have a vba script that is saving a worksheet as a .csv file
This correctly saves the .csv file, but depending on how I structure the data before .csv converting, I come across one of 2 errors in the output format compared to what I want.
Option 1
I have the data as a single text string, separated by commas in Column A.
When re-opening as a .csv in notepad, this shows the correct information, but with speech marks around the string.
i.e.
"a,b,c,d" rather than a,b,c,d
If I use this method, I need a way of removing the speech marks.
Option 2
I separate each bit of text into a column, however the final row of my data always has data in one extra column (an asterisk) to signify its the final line.
This cannot be removed as the .csv file requires this to be processed correctly.
Because of this, I get an additional, unwanted comma at the end of each row until the final line, highlighted in red below.
i.e.
a,b,c,d,
e,f,g,h,
i,j,k,l,*
Any ideas how I can get the desired output:
i.e.
a,b,c,d
e,f,g,h
i,j,k,l,*
Thanks
Rob
Bookmarks