+ Reply to Thread
Results 1 to 8 of 8

Help Breaking Down and combining names

  1. #1
    Registered User
    Join Date
    03-09-2012
    Location
    Oklahoma Citiy, OK
    MS-Off Ver
    Excel 2007
    Posts
    4

    Help Breaking Down and combining names

    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!

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Help Breaking Down and combining names

    Are there middle initials involved, differing mother/father last names, other salutions like Dr, etc...?

    Can you give a more realistic sampling of all possible combinations and expected results?
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    03-09-2012
    Location
    Oklahoma Citiy, OK
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Help Breaking Down and combining names

    The report from the powerschool program does not give any type of salutation, so it will be just Mr. & Mrs.; however, there are some children with only a mother or father. On rare occasion we will see a middle initials such as "Jones, William F.". Thanks

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Help Breaking Down and combining names

    Try these:

    Assuming Men start in A2, Women in B2, then in C2:

    Please Login or Register  to view this content.
    copied down

    in D2:

    Please Login or Register  to view this content.
    copied down

  5. #5
    Registered User
    Join Date
    03-09-2012
    Location
    Oklahoma Citiy, OK
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Help Breaking Down and combining names

    That is great....thank you so much....One issue...on the Mr. & Mrs. I need it to read: Mr. & Mrs. Bill Jones....the wife's name is not listed. Can you help.

  6. #6
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Help Breaking Down and combining names

    In D2 change formula to:

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    03-09-2012
    Location
    Oklahoma Citiy, OK
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Help Breaking Down and combining names

    That is so great. You have saved me a huge amount of time. Thanks & God bless you.

  8. #8
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Help Breaking Down and combining names

    You are welcome

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1