Add to a stock symbol

[Tenspeed39355]

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]

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]

tHANK YOU very much

Max

[MWE]

tHANK YOU very much

Max

Glad to help. Please mark this thread as solved.