samedi 30 novembre 2019

Conditional Formula: display text if cell contains

I want to change the display text in a cell if the cell contains a keyword. For example, I have a column with many similar text strings:

Christmas Tree - School A
Christmas Tree - School B
Christmas Tree - School C

In the above example, I would want the cell to simply display "Christmas Tree"

I can't work the customer formula in conditional formatting to achieve this. Possible?

Aucun commentaire:

Enregistrer un commentaire