Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-08-2014, 05:07 PM
Maxwell314 Maxwell314 is offline Need to extract two word domains from a list (BULK) Windows 8 Need to extract two word domains from a list (BULK) Office 2013
Novice
Need to extract two word domains from a list (BULK)
 
Join Date: Dec 2014
Posts: 10
Maxwell314 is on a distinguished road
Default Need to extract two word domains from a list (BULK)

Hi,



I need to extract all the two word domain names from a list of around 150,000 domains.

Here is a short example:

List of domains

thecarstore.com
carstore.com
goodtimes.com
myonlinestore.com
soccerguide.com
onlinebuilder.com
getafreequotetoday.com

Here is want I'm looking for

carstore.com
goodtimes.com
soccerguide.com
onlinebuilder.com

---
Can this be done with excel? Note that I can easily add and remove the ".com" if that makes it easier.

If anybody can help me with this it would highly appreciated!
Reply With Quote
  #2  
Old 12-08-2014, 05:50 PM
macropod's Avatar
macropod macropod is offline Need to extract two word domains from a list (BULK) Windows 7 64bit Need to extract two word domains from a list (BULK) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,343
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Unless you have spaces in the names, they're all one word as far as a macro is concerned.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 12-08-2014, 06:10 PM
Maxwell314 Maxwell314 is offline Need to extract two word domains from a list (BULK) Windows 8 Need to extract two word domains from a list (BULK) Office 2013
Novice
Need to extract two word domains from a list (BULK)
 
Join Date: Dec 2014
Posts: 10
Maxwell314 is on a distinguished road
Default

I will look into spacing the words out first.

If I am able to figure this out could excel extract all the ones containing just two words?
Reply With Quote
  #4  
Old 12-08-2014, 06:17 PM
macropod's Avatar
macropod macropod is offline Need to extract two word domains from a list (BULK) Windows 7 64bit Need to extract two word domains from a list (BULK) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,343
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Yes, that would be quite easy.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
bulk, domain

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to extract domain names containing only specific words (MAJOR BULK) Maxwell314 Excel 4 12-08-2014 05:10 PM
Need to extract two word domains from a list (BULK) How to change the list level in bulk ohnoezitasploded Word 1 10-12-2013 10:52 AM
Bulk Text alignment for multiple word files jbradf Word 0 08-29-2013 06:41 PM
How would I bulk select and copy highlights and then bulk paste them automatically? copywriterpro Word 0 04-19-2010 05:21 AM
Different email accounts for several different domains-how? Rkramkowski Outlook 0 03-03-2007 02:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft