Finding keywords in a text and displaying them in a single cell

[Bassie]

Hey everyone,

I am tryin to search keywords in a big text but cant figure out how. I have a cell with a big text in it and I want to find keywords in that text, if a keyword is found I would like for it to be displayed. To give a more clear example I made an XL2BB below. I would love for it to be a single cell formula if that is possible.

Book1
	A	B	C	D	E	F
1	Text	Formula goes here:		List of keywords:
2	asdasas red asdassadassa green asdasasd green asdasdsa purple asdadasd red	Red, Green, Green, Purple, Red		Red
3	sdadsa green	Green		Green
4	asdasasd purple asdasd red	Purple, Red		Yellow
5	asdasd Yellow Red	Yellow, Red		Purple
6
7
8
9
10
11
Sheet1

Thanks a lot in advance and if you have any questions please aske them!