Hi,
I have an excel file and cells A1 to A3 look like
"data1" "data2" "data3" etc if cell is empty then it shows as ""
When I save the excel as a CSV file, and open in Notepad, I get
"""data1""","""data2""","""data3""", etc if cell is empty then it shows as """"""
But I want
"data1","data2","data3", etc if cell is empty then it shows as ""
The "" are added to the data in each cell in a range by means of a macro - can i remove the macro and use a file format to ge tthe required result ?
What am I doing wrong ?
thanks
Steve
I have an excel file and cells A1 to A3 look like
"data1" "data2" "data3" etc if cell is empty then it shows as ""
When I save the excel as a CSV file, and open in Notepad, I get
"""data1""","""data2""","""data3""", etc if cell is empty then it shows as """"""
But I want
"data1","data2","data3", etc if cell is empty then it shows as ""
The "" are added to the data in each cell in a range by means of a macro - can i remove the macro and use a file format to ge tthe required result ?
What am I doing wrong ?
thanks
Steve