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