Hello,
I have an excel file with 1 column (Email) and each row has its own email address. I need to export it out into a text CSV file. I need the final format to be like so:
[email protected],[email protected],[email protected]
Can anyone help?
Thank you!
First transpose them into a single row rather than a column. (Copy>Paste special>Transpose) and then save as a CSV. Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you ChemisB That works!
=)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks