Errata to earlier formula (pasted the formula for B6, instead of B2)
.. try instead in B2, array-entered:
=IF(ISNA(MATCH(TRUE,ISNUMBER(FIND(E$2:E$6,A2)),0)) ,"",TRIM(INDEX(E$2:E$6,MATCH(TRUE,ISNUMBER(FIND(E$ 2:E$6,A2)),0))))

The above presumes that the strings searched for are always "embedded"
within the source cells with a leading space (as per your original post's
sample).

If that may not always be the case, just amend the source by inserting a
leading space as the 1st character in all source cells.
In an empty col, say in H2: =" "&A2
Copy H2 down, then copy col H and overwrite col A
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---