ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to I create a comma separated values file (https://www.excelbanter.com/excel-discussion-misc-queries/101920-how-i-create-comma-separated-values-file.html)

Ruby

How to I create a comma separated values file
 
I need to create a csv file in excel, to import from another program. Thanks

Peo Sjoblom

How to I create a comma separated values file
 
Save file as *.CSV



--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com



"Ruby" wrote in message
...
I need to create a csv file in excel, to import from another program.
Thanks




Atreus

How to I create a comma separated values file
 
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

harishkumar09

How to I create a comma separated values file
 

I have a list of email addresses separated by commas.I will just give
you a sample of the data

, "Mahesh Shah (Rekha)"
, "Ranna Rajdev" , "rekha
dodhia" , "Samir" ,
"Amita Joshi" , "abhay dagli"
, "pragna shah" ,
"Suchita Gujar" , "ashok kumar haria"
, "hardik malde" ,
"vinod (dingle)" , "desi masala"
, "Lucille Baker" ,
, "ramona tomkinson"
, "sonal shah"



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 ?


--
harishkumar09
------------------------------------------------------------------------
harishkumar09's Profile:
http://www.excelforum.com/member.php...o&userid=34826
View this thread: http://www.excelforum.com/showthread...hreadid=566104


Thomas

How to I create a comma separated values file
 
Try http://www.sqlscripter.com to export data to Text/Csv.

"Ruby" wrote:

I need to create a csv file in excel, to import from another program. Thanks



All times are GMT +1. The time now is 04:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com