Delete All??

[Geek Girl 007]

From this table, can I delete, just 2 colours? i.e. all the Blue and Pink?

Name	Colour
Jane	Blue, Pink Green, Purple, Red, Orange
Peter	Pink, Green, Red
Carol	Orange, Pink
Eva	Blue, Purple, Orange
Jodie	Green, Purple, Red, Pink
David	Red, Purple
Edwin	Green, Blue

 

[FormR]

TEXTSPLIT isn't available in 2021

I checked TEXTJOIN() was and made the leap that TEXTSPLIT() would be too !

 

[Geek Girl 007]

TEXTSPLIT isn't available in 2021 as shown in your profile.

Thank you