EXCEL 2010 Check if sub string value in cell match with other string from range of cells
- by gotqn
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
B2 text2sampletext
B3 text3sampletext
B4 text1sampletext
B5 text1sampletext
I have to check if text in column A is sub string of…