Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2004
    Posts
    361
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Parsing Names (excel 2002/xp)

    One can use the left function to parse a name such as Smith John to get Smith into a cell. Example =Left(a1,find(" ",A1)). What would the syntax be for a double last name? For example, Smith Jones Debbie La Belle Patti. Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Parsing Names (excel 2002/xp)

    It's hard to do - a formula cannot easily distinguish between

    Jones John Paul > Jones + John Paul
    Smith Jones Debbie > Smith Jones + Debbie

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Parsing Names (excel 2002/xp)

    I think your best bet is to parse (Data-text to columns) the entire thing into separate cells by space, then sort by how many cells it filled.

    The ones with 2 are easy. the ones with 3 you will have to decide if First, middle, last or First+First2, Last or First, Last+last2

    With more than 3 you have many more combinations that should be manually done.

    Once you have them separate, it is best to keep them separate and only combine as needed for "outputs".
    Steve

Posting Permissions

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