Extract all keywords from a cell based on a defined list

Hello experts,

I would need your help to write a formula to extract all the fruits in a cell, based on the list provided in a range.

For example

Input
A1----> Box1 has apples, orange Peach and banana
A2----> apple, jackfruit, in box2 along with banana and peach
A3----> Box no.3 has 100 guava,124 strawberrys

Desired Result
B1---->apples,orange,peach,banana
B2---->apple,jackfruit,banana,peach
B3---->guava,strawberry

The list of fruits to check is in the range N2:N10

Apple
Orange
Jackfruit
Guava
Strawberry
Lemon
Gooseberry
Peach
Banana

and i might add more fruits in to the list. Attached excel sheet to make it clear.

Thanks for your help.

Please Login or Register  to view this content.

Use ...

=MyConCat(A1,$N$2:$N$10)

Thanks @Phuocam & @Richard Buttrey. Both solutions works brilliantly.

You are welcome!