I am stuck with this one from hours.
I have range with cells with string values:
And other column with other string values like:
I have to check if text in column A is sub string of text in column B. If it is, to set in column C the text from column A.
B1 text1sampletext - C1 text1
B2 text2sampletext - C1 text2
B3 text3sampletext - C1 text3
B4 text1sampletext - C1 text1
B5 text1sampletext - C1 text1