Need to format CSV to inlude commas and single-quotes
Posted on 2010-08-30
I have an excel sheet with a single Column which is filled with email addresses.
I need to somehow format the list so that each email address is comma delimited, and has a single quote around it. So basically each cell needs to have a single quote around its content, and be comma delimited.
Here's how it looks now:
Here's my end goal:
'firstname.lastname@example.org', 'email@example.com', 'firstname.lastname@example.org'
Any ideas how to achieve this?