Convert CSV to Excel with replace single quote ' delimiter
I have a set of csv data which has single quote at the start and end as well. While converting it to the Excel leading single quote gets hidden due to excel significance. In the set of csv data only some values has leading single quote because of that i cannot use text to column function as well.
My aim is to do sum for all columns which i cannot do because of some leading single quote.