Text search for all the same stuff - order irrlevant

[CreativeUsername]

I'm working with a huge data set of full names compressed into a single cell. I have another cell on the same line with the same name but the order of the parts may or may not differ. Parts are separated by spaces.

So say Cell A1 is "John Q Doe" and cell C1 could be "John Q Doe", "Doe John Q", "Doe Q John" or "Q John Doe". I'd like to be able to run a formula that recognizes "all the same stuff" regardless of order as a "match" in C1 as compared to A1. Order is not important or a disqualifying factor.

Is that even possible?

 

[Joyner]

Hello Creative,

You need to give a little more info and maybe some actual examples and what you expect. So in your example do you expect to find John and Q and Doe from A1 each in C1? Are you looking for a VBA solution or a formula. Will there always be three things to look for, etc.