excel: wildcards (or something?) :p

alright, i'm trying to get excel to recognize when i'm trading ES.

currently, i use a line like this in excel: =IF(B2="ESH4", 50, "")

what i want to do is have excel still recognize ES when the contract changes. i want to do something like this: =IF(B2="ES*", 50, "")

anyone know a solution??

thanks!

 

=if(left(cell,2)="ES", then..,else..,)

 

Why don't you use the continuous contract ES #F if you are collecting data from Esignal ?

 

AmbushHillbilly, thanks. i will try that.

pspr, i do use ES #F when i do DDE with esignal. however, for this situation, it is dealing with my IB trades.