Use the instr function and check if it returns a number greater than 0. since
you are fimiliar with if then else and select I will not bore you with the
details...

HTH

"Wally Steadman" wrote:

Hello all,
I have a text string in cell A1 and I am trying to do an If Statement that
would place a certain value in B1 if something is contained in the text
string. I know this is probably simple, but have looked and I am stumped.

Cell A1 contains the following:
"a bulk order deed blessed small bulk order normal leather normal amount to
make: 10 female leather armor: 0, Price: --"

Notice it has a 10 in it. This value could be a 10, 15, or 20 so I wanted
to do something like:

If A1 contains "*10*" then B1 = "10"
Else if A1 contains "*15*" then B1 = "15"
Else if A1 contains "*20*" then B1 = "20"
End If

Or I could use a Select Case, but I think you see what I am trying to do.
Hope this is enough information

TIA

Wally Steadman