Excel string parsing with random character -

so, have string here xx.xx.xx.xx.xx.xx

i have check if of xx matches pattern. 10.10.10.??.10.??

why can't use exact(cell,"10.10.10."&??&".10."&??)

i mean, how can tell excel need of number match, don't care others?

hope it's clear, searched everywhere ._.

you need function accept wildcards (exact doesn't). try using countif, e.g. data in cell a1 can use formula

=countif(a1,"10.10.10.??.10.??")>0

that return true if there's match