3
votes
3answers
2k views

EXCEL 2010 Check if sub string value in cell match with other string from range of cells

I am stuck with this one from hours. I have range with cells with string values: A1 text1 A2 text2 An text3 And other column with other string values like: B1 text1sampletext ...