4
1
I'm using Numbers on my Mac at the moment and exporting to a CSV file. Is there a way to enclose every value with ""?
For example I'm getting the csv file like this:
1,2,3,4,5,6,7,8,9
When I want it like this:
"1", "2", "3", "4", "5", "6", "7", "8", "9"
I've tried doing this in Excel for mac too but haven't had much luck.
Thanks
1Nice thanks, felt a bit hacky but did the job – ingh.am – 2010-06-28T11:58:12.870
You can use =CONCATENATE("""",A1,"""") - (4 x ") - still hacky but more simple. – Mike Fitzpatrick – 2010-06-28T13:16:39.307