Excel question

PhillipMarlow

PhillipMarlow

Pheasant Heavy Breathing
Mar 14, 2008
1,762
34
0
Ok this is for keyword research...I've done the google SE3 and ninja SE2 and I still can't find exactly what I'm looking for...granted, I don't know anything about spreadsheets...

What I want to do is tell a cell to combine 1 keyword with each variation in the second column...so


how to buy blue widgets
where to buy green widgets
how much is red widgets


So that the output will be:

how to buy blue widgets
where to buy blue widgets
how much is blue widgets
how to buy green widgets
where to buy green widgets
etc

Can anyone help me out with this? I'm not even sure what the proper term is for what I'm looking for...
 


For simple string combinations in excel, use concatenate() and appropriate cell reference anchoring.

If you have two unique lists of substrings and you want to expand that to all possible combinations from those two lists, you need a macro.

See this thread for examples.
 
This is a pretty straight forward formula to output this.

Let's say you have all of your variations in column A. Fill column B with your keyword (type in row A, highlight it and the rest of the rows down and hit CRTL-D).

Now in cell C1, your forumla will be
Code: 
A1&" "&B1

This will output variation 1 from cell A1 followed by a space followed by your keyword from cell B1. Highlight cell C1 and CRTL-D down the rest of your highlighted rows and you'll have your list.
 
OP, what you wanna do will not be quick until you get your VBA Code or macros setup. It will take you some time to set this up.

There are some keyword tools on the internet that will do exactly this though. Good luck finding them though. They are bookmarked on a different computer that I don't have access to right now.
 
PhillipMarlow said:
Ok this is for keyword research...I've done the google SE3 and ninja SE2 and I still can't find exactly what I'm looking for...granted, I don't know anything about spreadsheets...

What I want to do is tell a cell to combine 1 keyword with each variation in the second column...so


how to buy blue widgets
where to buy green widgets
how much is red widgets


So that the output will be:

how to buy blue widgets
where to buy blue widgets
how much is blue widgets
how to buy green widgets
where to buy green widgets
etc

Can anyone help me out with this? I'm not even sure what the proper term is for what I'm looking for...
Click to expand...

Have you considered using winAutomation for jobs like these? There's a free 30 day trial. I know the guys who own the company and they are so helpful. They even copilot.com'ed with me one weekend just to help me out.....can't recommend them enough...
 
Thanks for the feedback peeps...I'll need to look into it more deeply...gonna try what skippy and brooklyn were suggesting.

Riddar--What's the difference between winAutomation and imacros? Are you talking about automating the keyword research itself?
 
PhillipMarlow said:
Thanks for the feedback peeps...I'll need to look into it more deeply...gonna try what skippy and brooklyn were suggesting.

Riddar--What's the difference between winAutomation and imacros? Are you talking about automating the keyword research itself?
Click to expand...

....Dude, all I can say it try it - seriously. It's free so you can't lose. The short answer is think mac vs. windows - before windows adopted the graphical, point and click style interface.

I love those guys and I can't say enough about them. Seriously they charge like $195/hr for custom programming (Nasa uses them) and a guy from their tech team spent like 1hr helping me for free put together a script that creates addon domains and interfaces with cpanel on autopilot.

I have no business ties with them. I just couldn't stop saying thank you though - perhaps it was just the greek hospitality but I see how word of mouth advertising works cause I have told like a billion people about them....
 
riddarhusetgal said:
....Dude, all I can say it try it - seriously. It's free so you can't lose. The short answer is think mac vs. windows - before windows adopted the graphical, point and click style interface.

I love those guys and I can't say enough about them. Seriously they charge like $195/hr for custom programming (Nasa uses them) and a guy from their tech team spent like 1hr helping me for free put together a script that creates addon domains and interfaces with cpanel on autopilot.

I have no business ties with them. I just couldn't stop saying thank you though - perhaps it was just the greek hospitality but I see how word of mouth advertising works cause I have told like a billion people about them....
Click to expand...


Are you saying what I think you're saying? If so, Viva la Sverija!!!
 
PhillipMarlow said:
Thanks for the feedback peeps...I'll need to look into it more deeply...gonna try what skippy and brooklyn were suggesting.

Riddar--What's the difference between winAutomation and imacros? Are you talking about automating the keyword research itself?
Click to expand...


PS I am repping you like totally hard for that autosig of yours - thanks!!
 
You must log in or register to reply here.
Top Bottom