Excel Help!!

Discussion in 'Automated Trading' started by tampatrader82, Sep 2, 2008.

  1. I have a question...Lets say I have 3 cells that look like this

    AFL TRV 1.0



    The three cells are basically two symbols and a factor. Does anyone know how to write a formula in excel to put those three cells together so that one cell will look like this:

    1.0AFL - TRV

    Basically, I am trying to make it simpler on myself in regards to inserting pair symbols into esignal. Any help would be much appreciated. Happy trading.

    Tampa
     
  2. It's called Concatenation, but just so you know, it changes everything into a text string.
     
  3. =D2&""&B2&" - "&C2
     
  4. Thank you very much, it works perfectly!