orPHP Code:
=TRIM(IF(LEN(SUBSTITUTE(A1;"black";""))<>LEN(A1);"black";"")&IF(LEN(SUBSTITUTE(A1;"blue";""))<>LEN(A1);" blue";"")&IF(LEN(SUBSTITUTE(A1;"red";""))<>LEN(A1);" red";"")&IF(LEN(SUBSTITUTE(A1;"green";""))<>LEN(A1);" green";""))
PHP Code:
=TRIM(IF(LEN(SUBSTITUTE(A1;H1;""))<>LEN(A1);H1;"")&IF(LEN(SUBSTITUTE(A1;H2;""))<>LEN(A1);" " & H2;"")&IF(LEN(SUBSTITUTE(A1;H3;""))<>LEN(A1);" " & H3;"")&IF(LEN(SUBSTITUTE(A1;H4;""))<>LEN(A1);" " & H4;""))