Help to match text which is slightly different

[calof1]

Hi,

I have a large data set, which the name differs slightly. Is there a way i can match the two.

Example match: 

State Street Australia Ltd ACF EQT ATF Alpha Global Opportunities Fund

Alpha Global Opportunities Fund

Thank you for your assistance.

[#2]

@calof1 

Could you provide few more sample data.  

Looking at your example a  following function should do the job. 

=ISNUMBER(FIND(B2,A2))

A2 = State Street Australia Ltd ACF EQT ATF Alpha Global Opportunities Fund

B2 = Alpha Global Opportunities Fund