I am stuck with this one from hours.

I have range with cells with string values:


>A1 text1 xyz

>A2 xyz text2 abc

>A3 text3 mnc cod

>A4 bbc text1 gog

>An abc goc 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 text in column B. If it is, to set in column C the text from column A.

Like this:

>A1 text1 xyz >C1 text1sampletext

>A2 xyz text2 abc >C2 text2sampletext

>A3 text3 mnc cod >C3 text3sampletext

>A4 bbc text1 gog >C4 text1sampletext

>An abc goc text3 >C5 text3sampletext

Thanks in advance
Kalu