Using the .Pattern Method for identifying Strings

Hi Guys,

I'm looking to implement the .Pattern method for Identifying Parts of String terms.

Basically I am looking for the Initials of a persons name from within a string.

Here are a few examples of strings where im trying to find the initials of the employee in:
1- "1700049757 WC- West Bull & Union DKT30868 08.00am " Here the initials to find are WC
2- "FSNe12265 - AD-JEWELLS 8687 D.C. HC01291" Here the initials to find are AD

Here are a few examples where I dont want to mistakenly find initials (Which don't exist within the string)
1- "A2027-replacement IV-90041. (LL - peal taps on ABS1291)
2- "A3040-Run ABC IV-90038 to IV-90041 & connect. Changeover; replace SL; remove OW etc"


In order to Identify the Initials the following conditions are always obeyed:
1. The Initials start and Finish with either a Space or a Dash (Can start with a space, finish with a dash, OR can start with a Dash and finish with a dash, ... All combinations of these)
2. The Length of the Initials is at Most Less than 5 Characters. (Due to some employees having the same 2 character initials some strings contain additional letters to identify on employee with the same initials to another employee, I.e. John Smith = JS, James South = JS... These initials would appear something like :JS, JSou
3. The initials Always start with numbers before them And before Point 1.
4. The first two characters of the Initials are Always Capitals


Please refer to my other post that is related to this question - Found Here: http://www.excelforum.com/excel-prog...ple-cases.html

Jordan

Try this

Please Login or Register  to view this content.

Do you mean like this?

Please Login or Register  to view this content.