Hi

Take a look at Earl Kiosterud's Text write program. That will write the
data out in the way you want
http://www.smokeylake.com/excel/text_write_program.htm

--
Regards

Roger Govier


"Dee" wrote in message
...
Thank you for your attempt to help. I think I am way over my head. I
have
entered several large data bases into excel with the hopes of
importing it
into another program. One of my lists is just email addresses:


www.wmorris.com



ANother list is addresses:
Lusardi Construction Co. 1570 Linda Vista Dr. San Marcos CA 92078
Roel Construction Co. Inc. 3366 Kurtz St. San Diego CA 92110
DPR Construction, Inc. 6333 Greenwich Dr. #170 San Diego CA 92122
I want to put a comma at the end of the info in each cell so I can
export it
into another database.


"Don Guillett" wrote:

I wonder why?

sub addcommaatend()
for each c in range("a2:a22")
c.value=c & ","
next c
end sub

--
Don Guillett
SalesAid Software

"Dee" wrote in message
...
aa,
and
aaaa aaaa,

"Don Guillett" wrote:

what do you want
aaaaaaa aaaaaa,
or
aaaaaaa,aaaaaa,
or
aa,

--
Don Guillett
SalesAid Software

"Dee" wrote in message
...
How do I put a comma at the end of text in all the cells in a
column?