Hello,

I have got some string:
test = "12aaa-cc-xxx"

and I need it compere with this mask:
mask = xxxx-xxx-xx-00

where x menas anything and 0 is needed

how can I do somethnig like this:
if test correspond mask then is True

Tom

Hello Tom,

If you are only checking the last two characters of the string, you ca
test it this way.

If Right(Test, 2) = "00" Then Result = True


Hope this helps,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=34660