How to I create a comma separated values file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create a csv file in excel, to import from another program. Thanks
 
If the question is simply how do I create a .csv then the answer is just to
save the file as a .csv file. However, you might alo want to know how to
import in directly from EXCEL into the next program. If this is what you are
trying to do post some more details about what the export to program is am I
may be able to help
 
I have a list of email addresses separated by commas.I will just give
you a sample of the data

<[email protected]>, "Mahesh Shah (Rekha)"
<[email protected]>, "Ranna Rajdev" <[email protected]>, "rekha
dodhia" <[email protected]>, "Samir" <[email protected]>,
"Amita Joshi" <[email protected]>, "abhay dagli"
"Suchita Gujar" <[email protected]>, "ashok kumar haria"
"vinod (dingle)" <[email protected]>, "desi masala"
(e-mail address removed), "ramona tomkinson"
<[email protected]>, "sonal shah"
<[email protected]>


I am looking for a VBA macro that can read this type of data and fill
up the first column with it.

A1,A2,A3 ... An should contain the email addresses.

Can you help ?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

.csv Commas ? 2
How to create '|' separated file 4
Files saved as csv files are actually saved as text files? 4
Changing commas in .csv to quotation marks 1
Excel CSV Files; Creating Of 3
Save as CSV: extra spaces around commas 2
How to create .csv file 2
csv files 1

Back
Top