Forum Discussion

Copper Contributor

Mar 10, 2020

Extraire points communs entre deux cellules

Bonjour, Je suis à la recherche d'une formule me permettant d'extraire uniquement la partie commune de deux cellules. Exemple 1: Cellule A contient "DE_2020XL" Cellule B contient "2020XV" >>...

excel

Formulas and Functions

ExcelExciting

MVP

Mar 10, 2020

Hi martinot96,

One solution that pop-up in my mind is using FLASH FILL, that might do the job for you.

as the length is not fixed, could you please share some more data to in Excel Workbook to understand the pattern of your data or do you have master list of all the products ?

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.

martinot96

Copper Contributor

Mar 10, 2020

Hey ExcelExciting,

Thanks a lot for your help.
I do not have a specific list of all the products, however what I would need is a formula able to detect when two cells include the same data basically.
So I could have one list of 2000 rows let's say, with plenty of different codes, and another list of 10 000 rows, and I'd like to do a kind of Vlookup but at the same time identifying the same patterns in the data.

My objective is to reconciliate the data from one list to another and identify which cell matches with another cell even though there are some differences.
It it clear to you ? 🙂

Thanks for your support, it's highly appreciated.
martinot96