[HELP] Split Domain Names into Words?

[iDestroyer]

Hi Guys,

First of all this is great forum, before opening this thread i already searched around and found some formulas that has helped me tremendously. I will be opening few more threads one after another to make things easy on my tiny brain.

as of now I want to do the following:
I have List of domains around 100k in Column A and I want to convert that list into keywords as shown below:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A (Domain List)[/TD]
[TD]B (Keyword)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Actanautoinsurancebuy.com[/TD]
[TD]Actan auto insurance buy[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Action-Supports.net[/TD]
[TD]Action Supports[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Activistfestival.org[/TD]
[TD]Activist Festival[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I have been using online tools to do this but it all has limits max. to 500 and I have to manage such 100k x 5 lists every single day, so it's quite painful to copy paste back n forth, I am trying to get as much things done in excel without using any online tools.

Hope my question is clear.

Thank you in advance.

 

[shg]

So would the result of expertsexchange.com be "experts exchange" or "expert sex change"?

That's not an isolated example.

Why is Actanautoinsurancebuy.com not "act an auto insurance"

Why is Action-Supports.net not "act ion supports"

 

[shg]

http://sphinxsearch.com/blog/2013/01/29/a-new-tool-in-the-trunk-wordbreaker/

 

[iDestroyer]

So would the result of expertsexchange.com be "experts exchange" or "expert sex change"?

That's not an isolated example.

Why is Actanautoinsurancebuy.com not "act an auto insurance"

Why is Action-Supports.net not "act ion supports"

I will accept any output, I can ignore such errors. largely it should just do the work.
also I do understand what you saying.

http://sphinxsearch.com/blog/2013/01/29/a-new-tool-in-the-trunk-wordbreaker/

Thanks for the link, will checkout soon. I will need time to understand the content of that post.