Match columns where a string/word exist in another column with more strings/words

Hi,
I need expert advise on how to compare/match two columns where data is not unique but contains matching data in MS Excel. compare column A and B and put results in column C. For example.

Column A:
1. "John S O"
2. "Mike PM"
3. "Justice C"

Column B:
1. "John Soap Orange"
2. "Mike Piper"
3. "Jackson Guy"

Column C: with search results
1. True
2. True
3. False

Here is one formula that you can try

=LEFT(A1,FIND(" ",A1)+1)=LEFT(B1,FIND(" ",B1)+1)

It compares the first name and the first initial of the last name in both columns.

Thank you so much...it works!!!

You're welcome. Happy to help.