Remove unique values within string

Hi Excel Forum,

I would like to create a macro that compares the values of two cells and outputs only the common values.

For example:

Cell A: "March April May June November December"
Cell B: "April May June July"
Cell C: "December March April"

After comparing B, with A, and C with the common values of A and B, I should receive the following output in Cell D: "April"

I have been pondering how to do this for months!

You're both fantastic; thank you very much!

Jindon, I managed to tweak your code to work within VBA provided there were no empty values within the range:

Please Login or Register  to view this content.

Thank you again!

If you want to ignore empty cell(s) then change to

Please Login or Register  to view this content.