simple late night cell formatting help-maybe too simple

[bfraser]

A1 B1

1234-TL TRAILER LOADER


If cell A1 contains "-TL" how can I format B1 to read "TRAILER LOADER"

 

[keymaster]

You need a formula, not formatting.


In cell B1 write =if(countif(a1,"*-TL*")>0,"Trailer Loader","")


This will display Trailer Loader in cell B1 whenever a1 has -TL anywhere in it.

 

[bfraser]

Thanks