Need to extract two word domains from a list (BULK)

Maxwell314 · #1 12-08-2014, 05:07 PM

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!

macropod · #2 12-08-2014, 05:50 PM

Unless you have spaces in the names, they're all one word as far as a macro is concerned.

Maxwell314 · #3 12-08-2014, 06:10 PM

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?

macropod · #4 12-08-2014, 06:17 PM

Yes, that would be quite easy.

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
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