View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Modifying regex to accept comma's?


On Fri, 26 Jun 2009 16:53:05 +0100, Simon Lloyd
wrote:

Aha!, got it with some playing around!
^[A-Za-z]{2}[,A-Za-z ]*$


That should work.

Here are some links you may find useful (if they are still good :-))

Regular Expressions
http://www.regular-expressions.info/reference.html
http://support.microsoft.com/default...02&Product=vbb
http://msdn2.microsoft.com/en-us/library/6wzad2b2.aspx
http://msdn2.microsoft.com/en-us/library/ms974619.aspx
http://www.regex-guru.info/
--ron