Compeering between cells values

Help StudioX
1

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

2

@nawaf7456
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

3

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

4

May be this would help