Searching for Specific Text in a Row

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

Hi Bryan,

Thanks for your reply. What I failed to mention was that the list is imported from a consistently changing text file. The words are not in the same location (cells, rows) very often, if they are there at all.

I appreciate your time looking at this.

Originally Posted by NewExcelUser

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

=IF(COUNTIF(1:1,"oranges"),"found","not found")
or
=IF(ISNUMBER(MATCH("oranges",1:1,0)),"found","not found")

copy down

Thank you so much for the help! Almost there. This is what I am looking for:

Instead of displaying "found," or "not found," can the found criteria be displayed?

Also, I would need the code to be modified to a four multiple criteria search

Lets say, search the row for "oranges", "apples", "pears", and "bananas." and if one of the words were found, the found word displayed?

Thank you sooo much. Your help is invaluable.

Thanks to all that have responded!! I have modified the code posted by teethless mama and it seems to work!

Please Login or Register  to view this content.

Thanks a million.