i have like 5 excel files, then i need to convert to csv extension. I save as .csv but besides export to .csv and it automatically add comma (when you open on notepad) , i need at the same time put doble quotes, theres a way to put double quotes ?
for example in excel i have
as fd gt vf
rt ed fv dsd
and when excel convert to .csv and you open in notepad it looks like:
as, fd, gt, vf,
rt, ed, fv, dsd
i need that at the same time he put double quotes "
for example
"as", "fd", "gt", "vf"
"rt", "ed", "fv", "dsd"
there's a way to do that, because it a huge work put it one by one.
Regards,
for example in excel i have
as fd gt vf
rt ed fv dsd
and when excel convert to .csv and you open in notepad it looks like:
as, fd, gt, vf,
rt, ed, fv, dsd
i need that at the same time he put double quotes "
for example
"as", "fd", "gt", "vf"
"rt", "ed", "fv", "dsd"
there's a way to do that, because it a huge work put it one by one.
Regards,