Thread: commas in cells
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
DEE DEE is offline
external usenet poster
 
Posts: 250
Default commas in cells

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?