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