in reply to Regex on excel

I see a logical problem here: what does a "partial" match mean?

Perl regexes either match or they do not match; Perl does not recognize "partial" matching. Are you wanting to sort by whether a regex matches an entire field value or part of a field value?