RegEx - Pattern Matching

Hello,

I have a macro that checks a cell against a RegEx. I am trying to find out what the RegEx is for the following.

These can be any number or letters

N – Number
L – Letter
/ “/”

NNNNNNL/NN

Example of a correct string 123456A/12

I have tried the following but it’s not working.

[0-9][0-9][0-9][0-9][0-9][0-9][A-Z]/[0-9][0-9]

Thanks in advance.

Paul

Perfect that has worked. Is there any way to change it so the letter can be upper or lower case?

Thanks again for all your help.

RegExp has IgnoreCase protocol, False for initial setting so something like

Please Login or Register  to view this content.

Will match to case insensitive.

It works! Thank you very much.

Paul