The earlier suggestion simply populates the table with the specific/key words
listed in B1 across where the search for these words within col A evaluates
to TRUE.

Conversely, if what you want is to strip the keywords listed in B1 across
from the original col A wherever it is found, ie have the stripped version of
col A populated within the table, then think we could try this instead in B2:
=IF(TRIM(B$1)="","",IF(AND(LEN(TRIM($A2))=LEN(TRIM (B$1)),ISNUMBER(SEARCH(TRIM(B$1),$A2))),SUBSTITUTE ($A2,B$1,""),IF(ISNUMBER(SEARCH(TRIM(B$1)&"
",$A2)),TRIM(SUBSTITUTE($A2,B$1,"")),$A2)))
Copy B2 across and fill down to populate, as before
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---