Home

Help to match text which is slightly different

%3CLINGO-SUB%20id%3D%22lingo-sub-764033%22%20slang%3D%22en-US%22%3EHelp%20to%20match%20text%20which%20is%20slightly%20different%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-764033%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20large%20data%20set%2C%20which%20the%20name%20differs%20slightly.%20Is%20there%20a%20way%20i%20can%20match%20the%20two.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%20match%3A%26nbsp%3B%3C%2FP%3E%3CP%3EState%20Street%20Australia%20Ltd%20ACF%20EQT%20ATF%20Alpha%20Global%20Opportunities%20Fund%3C%2FP%3E%3CP%3EAlpha%20Global%20Opportunities%20Fund%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20assistance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-764033%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-764394%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20to%20match%20text%20which%20is%20slightly%20different%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-764394%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F364226%22%20target%3D%22_blank%22%3E%40calof1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20provide%20few%20more%20sample%20data.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3ELooking%20at%20your%20example%20a%26nbsp%3B%20following%20function%20should%20do%20the%20job.%26nbsp%3B%3C%2FP%3E%3CP%3E%3DISNUMBER(FIND(B2%2CA2))%3C%2FP%3E%3CP%3EA2%20%3D%20State%20Street%20Australia%20Ltd%20ACF%20EQT%20ATF%20Alpha%20Global%20Opportunities%20Fund%3C%2FP%3E%3CP%3EB2%20%3D%26nbsp%3BAlpha%20Global%20Opportunities%20Fund%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
calof1
Contributor

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.

1 Reply

@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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies