commas in cells

[Guest]

How do I put a comma at the end of text in all the cells in a column?

 

[Guest]

Assuming your data start from A1
B1 =A1&","
copy down as far as needed

 

[Guest]

Thanks but what do you mean by copy down?

Assuming your data start from A1
B1 =A1&","
copy down as far as needed

 

[Don Guillett]

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

 

[Don Guillett]

I wonder why?

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

 

[Fred Smith]

Copy down means:

1. Enter the formula given, in this example, in B1.
2. Highlight cell B1.
3. You will see a box with a small square in the bottom right hand corner.
4. Grab that square with your mouse, and drag it down to the end of the column.
5. Excel will adjust your formulas as needed.

 

[Guest]

Would it be easier to save it as a comma deliminated file or comma separated
file (.CSV) using the save as file type?

Michael

 

[Roger Govier]

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