EDIT: Thanks everyone! I've managed to solve my issues. Could never have done it without your help, so thank you very very much. Stay safe!

Hello everyone. Thank you for reading my problem, and perhaps helping me find a solution

EDIT.

In attachment there are two sample files.

What I want to do is Identify the rows in Sample Two that have a matching row in Sample One.

To do this, I need to match column C in Sample Two (It contains dossier numbers) with the numbers in Sample one, namely those found in column K.

What is the problem? The dossier number in Sample Two are written like this 'B13 18849' The dossier number in Sample One are written in another format. Namely, '106587/B131884900-10001'.

Can I make a new column in Sample Two that compares both documents, and that looks for a (partial) match? (Note that the space between 'B131' and '8849' is only present in Sample two)

Thank you.