Word Match in a String

Hello Experts,

Need your help in finding an automated (VLKP or MATCH) way to compare text in two cells. Compare two texts and identify matching words and # of words matched.

Cell 1: How can I help you today sir?

Cell 2: ▲* how can help you today

Expected Result: how can help you
Word Match Count: 4

Would appreciate if you could share knowledge on how i can accomplish this in excel please. Thanks in advance

Just for testing.

Please Login or Register  to view this content.

Hi Takae,

Is this a VBA code ? Thanks

Hi John,

Thanks for the response. I don't know VBA. So, i have to go with your 2nd recommendation. All i need is a matching count between the texts. If my text is below:

Cell A1:

And thank you for the payment sir. Is there anything else I can help you with today?

Cell B1:

▼on ◆thank ▲you for that payment sir is there anything else i can help you with today

Result Expected:

Matching Count - 15