Excel Algorithm for domains

9 replies
I have a list of a few thousands urls in the form domain1.com , domain2.com , domain3.com etc and I want to be able to sort them out in the form of www.domain1.com , www.domain2.com , www.domain3.com etc or if needed do the opposite, does any of you guys know an excel algorithm or any web tool for this?
#algorithm #domains #excel
  • Profile picture of the author seasoned
    Originally Posted by kochtgr View Post

    I have a list of a few thousands urls in the form domain1.com , domain2.com , domain3.com etc and I want to be able to sort them out in the form of www.domain1.com , www.domain2.com , domain3.com etc or if needed do the opposite, does any of you guys know an excel algorithm or any web tool for this?
    WEB TOOL? Just use search and replace on notepad! I MIGHT suggest something else, but I KNOW that can't be what you want since you say "excel algorithm". And WHAT is an "excel algorithm" Do you mean the spreadsheet grid developed by visicorp?

    Steve
    {{ DiscussionBoard.errors[8182122].message }}
  • Profile picture of the author Valdor Kiebach
    So you want to either add 'www.' or remove 'www.'

    Is this what your are asking? I dont know what you mean by 'sort them out'
    {{ DiscussionBoard.errors[8182639].message }}
  • Profile picture of the author jeffreyhuan
    Type this in cell B1, and copy down.

    ="www."&A1

    This would also work:

    =CONCATENATE("www.",A1)
    {{ DiscussionBoard.errors[8182679].message }}
    • Profile picture of the author hsbinmarket
      Sorry ! I never heard about something called Excel Algorithm.
      Hope this post will give me some idea, wait for experts pls.
      Signature

      Do not put the links to a malware-infected site back in your signature

      {{ DiscussionBoard.errors[8182695].message }}
    • Profile picture of the author kochtgr
      Originally Posted by jeffreyhuan View Post

      Type this in cell B1, and copy down.

      ="www."&A1

      This would also work:

      =CONCATENATE("www.",A1)
      Thanks the first one worked, however how could I do the opposite and remove "www." if needed?
      {{ DiscussionBoard.errors[8183824].message }}
      • Profile picture of the author Bruce Wedding
        Originally Posted by kochtgr View Post

        Thanks the first one worked, however how could I do the opposite and remove "www." if needed?
        =RIGHT(A1,LEN(A1)-4)

        Note: -4 becuase "www." is 4 characters
        {{ DiscussionBoard.errors[8184044].message }}
      • Profile picture of the author Bruce Wedding
        Originally Posted by kochtgr View Post

        Thanks the first one worked, however how could I do the opposite and remove "www." if needed?
        =RIGHT(A1,LEN(A1)-4)

        Note: -4 because "www." is 4 characters
        {{ DiscussionBoard.errors[8184048].message }}
  • Profile picture of the author jeffreyhuan
    Another simple way to remove www is just finding "www." and replacing with "".
    {{ DiscussionBoard.errors[8187173].message }}

Trending Topics