Advanced Filter/Sort for Mixed Number and Letter Variables

I am trying to sort variables by numeric order with Advanced Filter/Sort.
What should I put in the "field" cell to do this? The variables have
different lengths, most (but not all) starting with a letter (or several
letters) then having four (sometimes three) numbers, then sometimes followed
with another letter. For example:

XXX304
I0068
Q5890X
BRI9890A

Thanks in advance!
.

Loading