I'm posting this again in the hopes that someone has an answer. I am not
having any luck with the 'Find' or 'Search' functions.

I am wanting to take a delimited string in a cell (B2) containing multiple
data elements and compare it to an array ($AA$2:$AA$10), then have the
matching data from the cell trimmed and displayed in a neighboring cell (C2).
I believe the best result would be for it to return the value(s) that match
one or more of the data elements in $AA$2:$AA$10.

From the example below, if I could have B2 contain the string, C2 would
contain the function that gives me the result of the match. For instance,
$AA$2:$AA$10 contains:

ACLEMON
BDUFOUR
BLANGLI
DDILUCE
DWELLS
ESCOTT
KRENKER
THUMENI
WROCHES

If B2 contains:

MROMANO|MTELLIG|JGURECK|MWOLK|LGAZDA|GVANBUH|CSHOA F|STILLER|RVERBIC|DSTEPHE|BLANGLI

C2 should return a result of BLANGLI. If there is more than one piece of
matching data, then it would be great if C2 could display the multiple items
in a new pipe-delimited string. Then, I want to do this for the remaining
cells (B3 to B146) in a successive list. Any advice on accomplishing this is
GREATLY appreciated. Thanks in advance!

Jeff Bloomer
Business/Reporting Analyst
Standard Register
www.standardregister.com