![]() |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
|
|
#1
|
||||
|
||||
|
[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 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Uppercase formula?
|
clements55 | Excel | 1 | 08-20-2014 11:34 PM |
Way to search for a string in text file, pull out everything until another string?
|
omahadivision | Excel Programming | 12 | 11-23-2013 12:10 PM |
Can I use the filter function to separate letters into separate files?
|
drhauser | Mail Merge | 2 | 12-14-2011 02:18 PM |
Day and Month to Uppercase
|
Andy2011 | Word VBA | 1 | 07-22-2011 04:34 PM |
Macro or Function to know wether a string is included in a text
|
Eduardo | Word VBA | 5 | 06-15-2009 01:55 AM |