![]() |
|
|
Thread Tools | Display Modes |
#4
|
||||
|
||||
![]()
[A-Z0-9-]{4,7} will find all the quoted examples, but it is a rather blunt instrument that will find upper case words and numbers of 4 to 7 characters also.
You are probably going to have to use two searches, because of the last item in your examples. For the others [A-Z]{2,3}-[0-9]{1,3} and for the odd one out [A-Z]{2,3}-[0-9]{1,3}-[A-Z]{1,} See http://www.gmayor.com/replace_using_wildcards.htm
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
Tags |
right function, upper |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
clements55 | Excel | 1 | 08-20-2014 11:34 PM |
![]() |
omahadivision | Excel Programming | 12 | 11-23-2013 12:10 PM |
![]() |
drhauser | Mail Merge | 2 | 12-14-2011 02:18 PM |
![]() |
Andy2011 | Word VBA | 1 | 07-22-2011 04:34 PM |
![]() |
Eduardo | Word VBA | 5 | 06-15-2009 01:55 AM |