PDA

View Full Version : enter commas



Tenspeed39355
10-23-2009, 06:14 AM
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
10-23-2009, 06:31 AM
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
10-23-2009, 06:35 AM
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:
Sub addComma()
Dim cCell As Range
For Each cCell In Selection
cCell = cCell & ","
Next
End Sub

Tenspeed39355
10-23-2009, 07:47 AM
Thanks for the quick reply. I will use that.
Good job.
Max