Hello,
I have been trying for the past several days on how to efficiently do the following:
I would like to search a cell for one of 3 specific texts and if one of these text is in the cell then copy or print this text in the adjacent cell.
For example:
Cell A1 contains the text "apple pear 55 hospital gate bn cn weq"
I need to look for the text "55 hospital" or "cat" or "dog" in A1 and if any one of these text exists, then copy that text into cell B1. If it doesn't then return a blank cell B1.
Therefore in the above example, B1 will return "55 hospital"
Hope someone will be able to help.
Thank you in advance!
Bookmarks