Searching a string of text using a formula

Hi

I am wanting to search a string of text (column A) for a name (column C), ideally a formula to search for two words (forename & surname) as they may be a middle initial on some records.

Regards
David