Wednesday, October 19, 2011

Salutation List Reference

Reference list for Salutations (English)

Prefixes, salutations or honorifics, such as "Dear Rt Hon Mr." John Q. Smith,

I had a request to parse prefix Salutations from a database of names and had troubles finding a comprehensive list.   Below is that list, along with links on how I did the parsing.

Shorter, common salutations are punctuated with and without periods while longer ones, by convention, are listed without punctuation (e.g. Rt Hon Mr  vs  Rt. Hon. Mr.). The referenced parsing routines use this list and the logic is easily changed for additional entries.

Leave an un-registered comment if you have additional salutations.  I purposely dropped the Pope and the Queen, figuring we would never need to write to them using a database and mail-merge.

Related articles:
Parsing First and Last Names in Excel
Parsing Salutation in Excel (Parses this list)

Parsing City State Zipcodes in Excel
Excel User-defined formulas

English Prefixed Salutations

Admiral
Air Cdre
Air Commodore
Air Marshal
Amb
Amb.
Ambassador
Baron
Brig
Brig Gen
Brig General
Brig.
Brigadier
Brigadier General
Bro
Bro.
Brother
Canon
Capt
Capt.
Captain
Cardinal
Cdr
Cdr.
Chief
Chief Warrant Officer
Cik
Cik.
Cmdr
Cmdr.
Col
Col.
Colonel
Commandant
Commander
Commissioner
Commodore
Congressman
Corporal
Cpl
Cpl.
Cpt.
Cpt
Dr
Dr.
Dr and Mrs
Dr. and Mrs.
Dr & Mrs
Dr & Mrs.
Father
First Lieutenant
First Officer
Flt Lieut
Fr.
Gen
Gen.
Generaal
General
Gov.
Governor
Group Captain
Grp Capt
Hon
Hon.
Honorable
Hr
Hr.
Judge
Justice
Lieut
Lieut Cdr
Lieut Col
Lieut Gen
Lieut.
Lieutenant Colonel
Lieutenant General
Lt Col
Lt Col.
Lt.
Maj Gen
Maj.
Major
Major General
Master Warrant Officer
Mayor
Miss
Mr
Mr.
Mrs
Mrs.
Ms
Ms.
Pr
Pr.
Pastor
President
Private
Prof
Prof Dr
Prof Dr.
Prof Sir
Prof.
Professor
Pvt
Pvt.
Rabbi
Rep.
Representative
Rev
Rev Canon
Rev Dr
Rev Mother
Rev.
Reverend
Rt Hon
Rt Hon Mr
Rt Hon Mr.
Rt Hon Ms
Rt Hon Ms.
Rt Hon Mrs
Rt Hon Mrs.
Rt Hon.
Rva
Sec.
Second Lieutenant
Secretary
Sen
Sen.
Senator
Sergeant
Sergeant
Sgt.
Sister
Sr
Sr D
Sr.
Sra
Srta
Sultan
Tan Sri
Tan Sri Dato
The Hon Dr
The Hon Dr.
The Hon Justice
The Hon Miss
The Hon Mr
The Hon Mr.
The Hon Mrs
The Hon Mrs.
The Hon Ms
The Hon Ms.
The Hon Sir
The Honorable
The Most Reverend
The Reverend
The Venerable
The Very Rev
The Very Rev.
The Very Reverend
Vice Admiral
Warrant Officer

No comments:

Post a Comment

Comments are moderated and published upon review.