Thanks in advance for your help.

In column 1, I have a text string which includes a numeral somewhere
in it. In column 2, I have numbers.

In column 3, I want to search the text in string in column 1 to see if
there is a "6" anywhere in the text and, if there is, I want to place
the number in column 2 into the current cell.

I thought a simple =if(A1 = "*6*", C1 = B1, 0) would work but it
always returns FALSE and, therefore, zero.