Here's one way:

Enter this formula in B1:

=IF(COUNTIF(A1,"*pre-owned*"),your_value_here,"")

Replace your_value_here with your value. If your value is a number just
enter that number: 10. If your value is a TEXT string enclose it in quotes:
"Yes".

The "" at the end will leave the cell blank if pre-owned is not found in
cell a1.

Biff

"Fish" wrote in message
...
I am looking for a way to populate a cell with a value if another cell has
a
certain word in it. If "A1" has "newark pre-owned" in it I would like to
search for "pre-owned" only and insert my value in "B1."

Thanks in advance for your assistance.

Fish