Hi,
I am trying to find the common/repeated text in Cell A2 AND Cell B2 and show the results in Cell C3
Eg:
Cell A2
Nice Job, agent 104
Cell B2
Great and nice, but what about 106
Result
Cell C3
nice
Referred some of the posts but they compare with the whole column which is not required...