Finding a value within a number/text

to extract begining and end of range from your two posted examples
in b1

=--LEFT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"-","",1),"!",""),":","-"),(FIND("-",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"-","",1),"!",""),":","-")))-1)

in c1

=--(LEFT(SUBSTITUTE(SUBSTITUTE(A1,"!","-"),":","-"),FIND("-",SUBSTITUTE(SUBSTITUTE(A1,"!","-"),":","-"))-1)&MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"-","",1),"!",""),":","-"),(FIND("-",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"-","",1),"!",""),":","-")))+1,255))

then in d1 dragged down
=IF(AND($E$1>=B1,$E$1<=C1),"found","not found")
with value to find in e1 (may be a problem if the last bit after ! or - is greater than 00-99)