How to extract continuous string set from a column with multiple criteria
I have a Column A with client names. Table 1 Table 2 Client Name Ongoing Projects Microsoft Corporation Ltd Microsoft BARCALAYS (LLP) Barcalays Caseys General Casey's LLP Ernst and Young Ernst and Young ASTRAZENCALimited Astrazanca
I want to search and extract the client names from Table 1 as below: Result Column Microsoft Barcalays Casey Ernst and Young Astrazenca
Basically the logic I am looking for is as below. The function/formula should check for continuous sequence of characters from Table B in Table A and return that entire sequence. Also this search should be case insensitive (For ex: BARCALAYS and Barcalays) and also the search text can be in between the within text column anywhere and not necessarily at the beginning (Ex: LLP Ernst and Youngand Ernst and Young). One important criteria is it should return matches for continuous string greater than 2 (i.e; 3 and above).
I tried various formulae like Search, Find, Minx, Left but I am not getting the desired result with the above set of criteria met. Please help me with the logical formula for this.
Happy to give any additional info pertaining to this.