PDA

View Full Version : Solved: Add to a stock symbol



Tenspeed39355
06-02-2005, 07:59 AM
There are two symbols for some funds. One of them is the Market price and the other is the NAV symbol. There might be 50 or more Market symbols in the ss.
Lets say they are in Column A. I want to put an X before the symbol and one
X after the symbol. Can I do a copy and paste from Column A into Column B
and put the XABCX in Column B. The question is there someway to automatic
put the Xs in column B? Thanks for your help
Max:friends:

MWE
06-02-2005, 08:45 AM
There are two symbols for some funds. One of them is the Market price and the other is the NAV symbol. There might be 50 or more Market symbols in the ss.
Lets say they are in Column A. I want to put an X before the symbol and one
X after the symbol. Can I do a copy and paste from Column A into Column B
and put the XABCX in Column B. The question is there someway to automatic
put the Xs in column B? Thanks for your help
Max:friends:
You could certainly do this with VBA, but that is not really necessary. You could use the CONCATENATE function built into Excel. If the symbols are in col A, then code in cell B1 the following =CONCATENATE("X",A1,"X"). Then copy and paste down col B

Tenspeed39355
06-02-2005, 09:42 AM
tHANK YOU very much

Max

MWE
06-02-2005, 07:04 PM
tHANK YOU very much

Max

Glad to help. Please mark this thread as solved.