Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi, I have the title, first and surnames of a list of people in one column, it is proving difficult for sorting. Is there code I can use to extract the title?

    Many thanks, Darren.

  2. #2
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts
    [quote name='iksotof' post='774657' date='11-May-2009 09:07']Hi, I have the title, first and surnames of a list of people in one column, it is proving difficult for sorting. Is there code I can use to extract the title?

    Many thanks, Darren.[/quote]

    If the Title is the first item listed and is always seperted by a comma (,) from the first and surnaems; the below formula will extract the Title which then can be used to sort the data.

    =LEFT(A1,FIND(",",A1)-1)

    Tom Duthie

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts
    [quote name='duthiet' post='774663' date='12-May-2009 01:07']If the Title is the first item listed and is always seperted by a comma (,) from the first and surnaems; the below formula will extract the Title which then can be used to sort the data.

    =LEFT(A1,FIND(",",A1)-1)

    Tom Duthie[/quote]
    Alternatively, if there's a space separator:
    =LEFT(A1,FIND(" ",A1)-1)
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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