Hi again,

I think this ought to be pretty easy, but I just don't know how to do it!

I have this text in different cells in a row. In this example, the cells are separated with a "-"

Row1: apples - oranges - bananas - peaches - plums - pears - tomatoes

Row2: candy - clothes - jacket - pants - sweater - oranges - socks

What I would like to do is search for the text "oranges" in row one and IF FOUND put the found text into a different cell all together. I would like the same thing to happen with row 2, 3 , 4 and so on.

Thank you for your time! I appreciate everyones help