iDestroyer
New Member
- Joined
- Feb 23, 2018
- Messages
- 2
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.
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.
