Excel Algorithm for domains

Posted: 12 years ago 9 replies

INTERNET MARKETING

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

12 years ago

Originally Posted by kochtgr

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

[ 0 ] Thank this user

Valdor Kiebach

Valdor Kiebach

Valdor Kiebach

Posts: Threads: Thanks: Account age: less than a second

12 years ago

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'
- [ 0 ] Thank this user
- 1 reply
- kochtgr
  
  kochtgr
  
  kochtgr
  
  Posts: Threads: Thanks: Account age: less than a second
  
  12 years ago
  
  Originally Posted by 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'
  
  Yes pretty much that is what I am asking for...
  
  [ 0 ] Thank this user
  
  Signature
  
  Want to know How you Should use Guest Blogging in 2016 ?
jeffreyhuan

jeffreyhuan

jeffreyhuan

Posts: Threads: Thanks: Account age: less than a second

12 years ago

Type this in cell B1, and copy down.

="www."&A1

This would also work:

=CONCATENATE("www.",A1)
- [ 1 ] Thank this user
- 2 replies
- hsbinmarket
  
  hsbinmarket
  
  hsbinmarket
  
  Posts: Threads: Thanks: Account age: less than a second
  
  12 years ago
  
  Sorry ! I never heard about something called Excel Algorithm.
  Hope this post will give me some idea, wait for experts pls.
  
  [ 0 ] Thank this user
  
  Signature
  
  Do not put the links to a malware-infected site back in your signature
- kochtgr
  
  kochtgr
  
  kochtgr
  
  Posts: Threads: Thanks: Account age: less than a second
  
  12 years ago
  
  Originally Posted by jeffreyhuan
  
  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?
  
  [ 0 ] Thank this user
  
  2 replies
  
  Signature
  
  Want to know How you Should use Guest Blogging in 2016 ?
  
  Bruce Wedding
  
  Bruce Wedding
  
  Bruce Wedding
  
  Posts: Threads: Thanks: Account age: less than a second
  
  12 years ago
  
  Originally Posted by kochtgr
  
  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
  
  [ 1 ] Thank this user
  
  Signature
  
  $2,300 in a Week With Teespring
  
  Bruce Wedding
  
  Bruce Wedding
  
  Bruce Wedding
  
  Posts: Threads: Thanks: Account age: less than a second
  
  12 years ago
  
  Originally Posted by kochtgr
  
  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
  
  [ 0 ] Thank this user
  
  Signature
  
  $2,300 in a Week With Teespring
jeffreyhuan

jeffreyhuan

jeffreyhuan

Posts: Threads: Thanks: Account age: less than a second

12 years ago

Another simple way to remove www is just finding "www." and replacing with "".
- [ 0 ] Thank this user

Excel Algorithm for domains

Trending Topics

How to host LinkedIn live events

Hello everyone! I'm new here and excited to learn and share. Looking forward to your support!

Hello! New Member Here, Excited to Learn and Share!"

Geotargeting in TikTok Ads

Digital marketing for freelancing as a beginer

Bouncer - Powerful and secure email verification platform