=SUBSTITUTE Problem

I would like to be able to use OR in substitute, to say remove red or blue or green if it appears in cell.

A1
red tiger

B1
green turtle

C1
blue fish


=SUBSTITUTE(A1,("red "or"blue "or"green "),"")

Try this in D1

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"red",""),"green",""),"blue","")

Drag across to F1

Hope this helps

I'm not a formula whizz-kid, perhaps it can be simplified?

In the meantime you might also want to try

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"red ",""),"green ",""),"blue ","")

Note the space after the colour.

or

=TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"red",""),"green",""),"blue",""))

these examples will remove leading spaces as in your sample data.