Match words in two cells in two columns and return the unmatched words

[divuraj]

Hi,

I need urgent help on this.

I have the cell value in A4 as "Meeting with Client to happen in the wk of 4/15 and will update the comments after the meeting."
and in cell B4 I have "Meeting with Client(Peter) to be scheduled for wk of 4/15 and will update the comments after the meeting."
now i need to compare them and find out the uncommom words between A4 and B4 and retrieve result in C4 as
"(Peter) to be scheduled for".

Can you please help me, i used a macro which checks each character and compares but it is not working.

Any help would be greatly appreciated.

Regards,
Divu.

 

[divuraj]

any luck on this? can anyone please guide please?