1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

sorting by n letter

Discussion in 'Software' started by psYCHopath, 18 Mar 2008.

  1. psYCHopath

    psYCHopath What's a Dremel?

    Joined:
    25 Dec 2001
    Posts:
    309
    Likes Received:
    0
    I have a list of domains scanned using godaddy bulk

    EAAC.INFO
    EAAD.INFO
    EAAF.INFO
    EAAG.INFO
    EAAH.ORG
    EAAH.INFO
    EAAJ.ORG
    EAAJ.NET
    EAAK.ORG
    EAAK.NET

    is there a way in excel or msword or open office or a software where i can sort by the 6th letter?
    so it becomes

    EAAC.INFO
    EAAD.INFO
    EAAF.INFO
    EAAG.INFO
    EAAH.INFO
    EAAJ.NET
    EAAK.NET
    EAAH.ORG
    EAAJ.ORG
    EAAK.ORG

    :waah:
     
  2. jonatron

    jonatron What's a Dremel?

    Joined:
    1 Sep 2005
    Posts:
    19
    Likes Received:
    0
    You could use the MID() function in excel to extract the sixth letter in a separate column and then sort by this column.
     

Share This Page