enter commas

[Tenspeed39355]

Hi I have around 600 symbols in Column A.
I need to enter a comma after each symbol. Is there a way
to do that?
Example: ACG,
Thanks Max

[Bob Phillips]

Put a comma in B1, copy down

On C1, add =A1&B1, copy down

Then copy and PasteSpecial>Values in column C and delete A & B

[mbarron]

A non VBA solution would be:
=A1 &","
copy down and then do a copy and paste special ... Values option over the original column.

or if you want a macro
select your range and use:
[VBA]Sub addComma()
Dim cCell As Range
For Each cCell In Selection
cCell = cCell & ","
Next
End Sub[/VBA]

[Tenspeed39355]

Thanks for the quick reply. I will use that.
Good job.
Max