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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.