Hi,

I'm facing a problem which wastes a lot of time for me and I hope someone can help me.

I have data in columns A and B. Cells in column B contains values like in column A, but each cell has few more letters. For example, value in column A is 1234, value in column B is w1234xy. So code is there, however, covered in additional letters.

Is there a way to find cells in column B, that has values like in column A, even though they are between letters, and align matching cells?

Many thanks!
Karolis