Compeering between cells values

hi, I have 2 cells with many word , is their any way to extract the duplicated values?

welcome to the forum

we can apply different techniques depending on the details. May we ask you for some sample data of your case. Thanks

Book1.xlsx (11.6 KB)
as you can see I have 2 sheets I want to take the duplicated courses and save it in new cell

May be this would help