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
Bookmarks