I need to add a comma after everything in a colum... how?

[higman.schmidt]

how do i do this...

i have text in a series of cells in a colum... i want to add a comma after
the text in each cell... the text is different in each cell.... how do i do
this????

 

[Anne Troy]

You could insert a column to the right and do something like =A1&","
************
Anne Troy
www.OfficeArticles.com

 

[higman.schmidt]

OK ive figured it out.... after searching for an hour or two i found that you
can just use the
=concatenate(k1," ,",c3," ",c4)
where k1 is the physical address
c3 is the city
c4 is the state

this outputs
physicaladdress, city state

 

[Anne Troy]

Sure. If you use =k1&", "&c3&","&c4, then you don't even need the
concatenate part.
************
Anne Troy
www.OfficeArticles.com