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
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
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
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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]
Thanks for the quick reply. I will use that.
Good job.
Max