I have a workbook with two sheets Data and URM
In sheet "URM" in column F ("URM") I have details of URM
In sheet "Data" in Column "E"(Remarks) I have sentences.
I wants to check that whether any of the sentences in "E" in Sheet "Data" contains the URM from the sheet "URM"
Some senetence in Remaks might contains more than one URM. In that case extract all the URM and separate with "^". Example given in attachment marked in green colour
URM might me part of sentence in Remakrs column delimited by space and other symbol or without space also.
So have to look for exactly as in URM column
If URM found in next Column(Column"F") in sheet "Data" show the same URM. if not found shouw result as "NO URM"
Bookmarks