Consulting

Results 1 to 4 of 4

Thread: Add to a stock symbol

  1. #1

    Add to a stock symbol

    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

  2. #2
    VBAX Expert
    Joined
    Feb 2005
    Posts
    929
    Location
    Quote Originally Posted by 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
    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

  3. #3
    tHANK YOU very much

    Max

  4. #4
    VBAX Expert
    Joined
    Feb 2005
    Posts
    929
    Location
    Quote Originally Posted by Tenspeed39355
    tHANK YOU very much

    Max
    Glad to help. Please mark this thread as solved.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •