Excel Help!!

[tampatrader82]

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

 

[MandelbrotSet]

It's called Concatenation, but just so you know, it changes everything into a text string.

 

[eminitrader007]

Quote from tampatrader82:

I have a question...Lets say I have 3 cells that look like this
1 B C D
2 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

=D2&""&B2&" - "&C2

 

[tampatrader82]

Thank you very much, it works perfectly!