I have an exported file from a program that has the names of the parents of our students at school. One field has mothers name (ie: Smith, Jane) and one field has the fathers name (ie: Smith, Bob). I am needing to make two different fields....Short Salutation - Bob & Jane and a Long Salutation - Mr. & Mrs. Bob Smith. Can anyone help with formulas to do this? Many Thanks!