Copy and Paste

[webmal]

Usually I would copy a set of stock codes from Etrade (online) and then paste it to Excel for my records. The data would appear in columns e.g.:

ABC
DEF
GHJ

Then I need to copy the codes to my trading software to examine the charts further. The format my software use is ABC,DEF,GHJ to open those charts. Sometimes I have hundreds of codes. To avoid manual input, what's the easiest way to format the codes?

Thank you.

 

[DrPizza]

I don't know if there's a simpler way to do it, (there's gotta be)
So, I'd just write a quick macro that would write the string, insert a comma, move down a box, write the next string,...
Then, a simple loop, with a test for the end to exit the loop. Either have it check for a blank entry to end, or maybe manually enter an xxx and just compare it that way.