Excel: Help with Regular Expression pattern


Hi, I've managed to identify a string which starts with a Capitol A-Z followed by a number [0-9] and then a period and space. However the number may be over 10 (so more than one character) and in some case the period and space missing. This may mean two checks are needed but I can't get either working properly. Have Googled a bit but can't find a good pattern tutorial for beginners for VBA RE... if you know of one I'd appreciate a link. Many thanks, ABB


This question generated 27 answers. To proceed to the answers, click here.

This thread is current as of October 02, 2013.


For more resources for Microsoft Excel