Been looking all over and can't seem to find an answer. Can u help?
I want to see if a specific pattern exists within a series of text codes. Codes are separated by a spaces.
The pattern I'm looking for is: "O" "DO" "O". Any "O" found cannot part of another code (for example: "DO" "OS"). Has to be on its own.
Here is a sample of the text codes (cells AM3:AM8):
O I H D DO H O (meets the pattern)
O I H D DO H OS (does not)
D DO H DO H O (does not)
O I H D DO H O H DO OS (meets)
D DC O DO I DO H OS O (meets)
D DO D DO D O D DO D H OS (does not)
This formula finds ALL occurrences of the pattern - even when the "O" code is part of another code: =IF(ISNUMBER(SEARCH("O*DO*O", AM3)),"YES","")
Any way to isolate the "O"s?
Much appreciated.
- NZDZY2
Bookmarks