Non vba equivalent to ISLIKE?

[merlin777]

is there a non vba equivalent to ISLIKE?

I'm trying to validate a mixed text/numeric entry against 2 critera and this might do the job.

My entry must be in the form 'POnnnnnn' where nnnnnnis between 100000 and 999999 and preceded by 'po' or 'PO'.

 

[T. Valko]

Argh!

I tested a bunch of "E" numbers but not that one!

Lightly tested:

=AND(LEN(A2)=8,LEFT(A2,2)="po",COUNT(-MID(A2,ROW(INDIRECT("2:8")),1))=6,--RIGHT(A2,6)>=100000,--RIGHT(A2,6)<=999999)

Note that if you test this as a formula on the worksheet then it has to be array entered.

Array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.