Welcome to Welcome to DNF.com™ - Domain Sales, Domain Forum, Domain Appraisals, Domain Registrars

If you are new to domains and looking to buy, sell and learn about domains then you have come to the right place. DNForum is the largest domain name community on the internet and continues to grow every day. There are over 105,000 domainers on DNForum doing everything from buying domains, selling domains, learning about domains and discussing domains. Take a minute and Register.

Register Today on DNForum IT'S FREE!

Results 1 to 7 of 7
  1. 04-03-2005, 04:08 AM #1
    MediaHound
    MediaHound is offline
    Former DNF Admin
    MediaHound's Avatar
    Join Date
    Feb 2004
    Location
    Florida
    Posts
    4,896
    Blog Entries
    1
    DNF$
    15,980
    Bank
    0
    Total DNF$
    15,980
    Donate  

    excel help - how can I sort a list by length

    I have a large list of names, all mixed up lengths.
    I wish to open the list in excel, then sort the list of domains by length.
    Have the 2 char domains at the top, followed by the three char, then 4 and so on and so forth.
    Could anyone give any clues?
    Submit your domains here:
    www.Bido.com/SubmitDomains
    Vote For Profits
    Reply With Quote Reply With Quote
  2. 04-03-2005, 04:35 AM #2
    Honan
    Honan is offline
    Honan's Avatar
    Join Date
    Mar 2003
    Location
    Australia
    Posts
    4,084
    Country

    Australia Add Honan on Facebook
    DNF$
    3,284
    Bank
    0
    Total DNF$
    3,284
    Donate  
    Send a message via Skype™ to Honan

    Re: excel help - how can I sort a list by length

    Quote Originally Posted by MediaHound
    I have a large list of names, all mixed up lengths.
    I wish to open the list in excel, then sort the list of domains by length.
    Have the 2 char domains at the top, followed by the three char, then 4 and so on and so forth.
    Could anyone give any clues?
    Put the list in column A
    In Column B Row 1 type =LEN(A1) This gives you the length of A1
    Edit Fill down B1 down Column B so you have =LEN(A2) etc
    Copy, paste special, Values only , Column B
    Highlight all
    Now, data sort

    Clears as mud?
    JOES.com.au Graduate of the DNF College
    Reply With Quote Reply With Quote
  3. 04-03-2005, 05:10 AM #3
    MediaHound
    MediaHound is offline
    Former DNF Admin
    MediaHound's Avatar
    Join Date
    Feb 2004
    Location
    Florida
    Posts
    4,896
    Blog Entries
    1
    DNF$
    15,980
    Bank
    0
    Total DNF$
    15,980
    Donate  

    Re: excel help - how can I sort a list by length

    In Column B Row 1 type =LEN(A1) This gives you the length of A1
    Edit Fill down B1 down Column B so you have =LEN(A2) etc

    little muddy - but this info was enough to get me unstuck

    brilliant

    thanks
    Submit your domains here:
    www.Bido.com/SubmitDomains
    Vote For Profits
    Reply With Quote Reply With Quote
  4. 01-25-2012, 12:07 AM #4
    ryanmlanane
    ryanmlanane is offline
    Platinum Lifetime Member
    Join Date
    Oct 2010
    Location
    Canton, IL
    Posts
    599
    Country

    United States
    DNF$
    3,418
    Bank
    0
    Total DNF$
    3,418
    Donate  
    I hate excel, but how do I "Edit Fill down B1 down Column B so you have =LEN(A2) etc"

    I got the first part, easy ... <Noob> !
    FREE LIST OF AVAILABLE DICTIONARY.IN DOMAIN NAMES TO HAND REG @ CATCH NAMES
    Reply With Quote Reply With Quote
  5. 01-25-2012, 12:28 AM #5
    silentg
    silentg is offline
    silentg's Avatar
    Join Date
    Feb 2010
    Posts
    2,276
    Country

    Canada
    DNF$
    7,791
    Bank
    0
    Total DNF$
    7,791
    Donate  
    Thread is 6+ years old


    █ Laptop Hard Drive
    █ Cooking Games
    █ Makeup Games
    Reply With Quote Reply With Quote
  6. 01-25-2012, 12:48 AM #6
    dmyre
    dmyre is offline
    Join Date
    Apr 2002
    Posts
    2,772
    DNF$
    3,004
    Bank
    0
    Total DNF$
    3,004
    Donate  
    Quote Originally Posted by silentg View Post
    Thread is 6+ years old
    It's still useful though.
    This isn't something that I would have thought to search for.
    Reply With Quote Reply With Quote
  7. 01-25-2012, 03:31 AM #7
    ryanmlanane
    ryanmlanane is offline
    Platinum Lifetime Member
    Join Date
    Oct 2010
    Location
    Canton, IL
    Posts
    599
    Country

    United States
    DNF$
    3,418
    Bank
    0
    Total DNF$
    3,418
    Donate  
    Quote Originally Posted by dmyre View Post
    It's still useful though.
    This isn't something that I would have thought to search for.
    Found it on Google

    SilentG - I know what would make you happy. Buying 93games.com from me
    FREE LIST OF AVAILABLE DICTIONARY.IN DOMAIN NAMES TO HAND REG @ CATCH NAMES
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. _ LIST of 24511 US Cities/Towns, great for new regs, 6 columns to sort it by!
    By Prosperous in forum DNF$ Sales/Domain Auctions
    Replies: 3
    Last Post: 03-20-2005, 08:34 PM
  2. >>>_ LIST of 24511 US Cities/Towns, great for new regs, 6 columns to sort it by!
    By Prosperous in forum Advertising and Related Offers
    Replies: 4
    Last Post: 03-08-2005, 11:13 AM
  3. 50 DNF$ for those who can sort this list alphabetically.
    By tekz999 in forum DNF$ Sales/Domain Auctions
    Replies: 13
    Last Post: 11-27-2004, 12:49 AM
  4. Hot, Fresh One Word .Info List! Commercially Viable.
    By wordplay in forum Advertising and Related Offers
    Replies: 0
    Last Post: 01-24-2004, 09:06 PM

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
  •  

Forum Rules

Domain name forum recommended by Domaining.com