Search letters and numbers to see if exist in another column by at least 7 characters

Hi Glenn and thank you for helping me out.

I am now trying in Excel 2010. To answer your questions
1. No, they can vary in length as they are passport numbers from different countries
2. I will add now, sorry for that
3. I did try this in column C2 but it gives "No match" in all thew columns.

Do you have any other ideas of what I do wrong since you obviously got the correct result?

Many thanks!