How to define number of match in Regular Expression for Match Regular Expression function?

[Anne Zuo]

Hi,

I am trying to use Match Regular Expression function to check if string matches certain format, say 5 charactars and 6 digitals. How to define it in regular expression?

Format [A-Z]+[0-9]+  will not limit the number of matches.

I can do  [A-Z][A-Z][A-Z][A-Z][A-Z][0-9][0-9][0-9][0-9][0-9][0-9], but any better way?

Thanks for any help.

Anne

[Anne Zuo]

I got it.