Hi! Am using MS Office 2007,

I have a list of Names followed by the City and State, I need to separate the the Names, City and States

Eg:

Mr.Thomas B Fernan dez New York.NY
Mr.Bar ry K Olivia Houston.TX
Ms.Dor othy D Hawell Rocky Mount.NC
Mr.Tho mas L Morg Deerpark.NY
M rs.Jennifer D Lebl anca Carlisle.PA


Expected Result:

Mr.Thomas B Fernandez <tab>New York.NY
Mr.Barry K Olivia <tab>Houston.TX
Ms.Dorothy D Hawell <tab>Rocky Mount.NC
Mr.Thomas L Morg <tab>Deerpark.NY
Mrs.Jennifer D Leblanca <tab>Carlisle.PA

Suggestions:

1. Take off all <SPACE> continued by small letters (Fernan dez - Fernandez; Bar ry - Barry; Dor othy - Dorothy; M rs. - Mrs.; Lebl anca - Leblanca, so on......)

2. Names always have the same format. i.e.: SALUTATION.<FIRSTNAME>SPACE<Initial of MIDDLE NAME>SPACE<LAST NAME>

3. Place a <TAB> before the 5th Capital Letter, i.e. before city 'New York' in first case.

which can give the above mentioned result.


Its really urgent for me! Please help me out! (pls mention if it can be better done with MS Excel)

Thank you in advance! your early reply is highly appreciated.