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