Formula to match partial text string. - MrExcel.com

I am here for general knowledge, looking for a formula that can match partial text strings to full ones. Is this even possible to do in excel? What would be the best ...

www.mrexcel.com