Bet you don't know this answer!!

Scotland

Regular Member
Joined
Apr 4, 2009
Messages
379
Reaction score
207
Hey ppl,

Ive got keywords entered into a spreadsheet file. There are 4 columns of keywords, the first has phrases like...how do i. The second column contains words such as lose weight, the third contains keywords like quickly and easily...

Anyway, ive got about 50 keywords in each column, and what i would like to do is mix each and every keyword together so that i create 2 word, 3 word and 4 word phrases.

I need to cover every combination basically and was wondering how i could a) do this and b) automate it...

I will gladly share all the keywords to anyone who can help me out
 
Fuck...my wife just got on a plane for a biz trip. I won't hear from her until later tonight but I'll send this to her. She is the goddess queen of excel, could probably knock it out in a minute or two.
 
that is an excellent question!
you could probably do it with a macro. Maybe
You can definitely do this in access or some other db program.
 
Fuck...my wife just got on a plane for a biz trip. I won't hear from her until later tonight but I'll send this to her. She is the goddess queen of excel, could probably knock it out in a minute or two.


Am I nerd for thinking this would be a +1 in a girl?
 
Ive found a website that allows you to combine the 3 colums, you can only enter in a maximum of 12 per column, but this does exactly what i want. It looks like its a php script, id actually pay for this script cos i see good potential for it....

Any idea how to get the php script?
 
Sorry , im so stupid!!

hxxp://www.searchenginepromotionhelp.com/m/keywords-combiner/word-combinations.php

If this could be extended to more words in each colums, mixed with product keyword and buying keywords, this could be quite a good tool to source out some longtail keywords.

Anyone else think this??
 
Use a concatenation formula in Excel in a separate column to combine labels or strings:

[FONT=Arial,Helvetica][SIZE=-1]Step-by-Step:[/SIZE][/FONT]
[FONT=Arial,Helvetica][SIZE=-1]Cells F129 contains Mary and G129 contains Brown[/SIZE][/FONT]
[FONT=Arial,Helvetica][SIZE=-1]Another cell, say, F132 contains the concatenation formula: =F129&G129[/SIZE][/FONT]
[FONT=Arial,Helvetica][SIZE=-1]F132 will display: MaryBrown[/SIZE][/FONT]
 
Use a concatenation formula in Excel in a separate column to combine labels or strings:

[FONT=Arial,Helvetica][SIZE=-1]Step-by-Step:[/SIZE][/FONT]
[FONT=Arial,Helvetica][SIZE=-1]Cells F129 contains Mary and G129 contains Brown[/SIZE][/FONT]
[FONT=Arial,Helvetica][SIZE=-1]Another cell, say, F132 contains the concatenation formula: =F129&G129[/SIZE][/FONT]
[FONT=Arial,Helvetica][SIZE=-1]F132 will display: MaryBrown[/SIZE][/FONT]

That worked a treat too!!
 
Send me the list. I will create 50x50x50x50 lines and send it to you. How I do it? I program it.
 
concatenation will work You can create a sheet that will use that.It'' just take a a bit of time to create a 50X50X50 concatenation. I thought there was another way in excel...

Other than that it's string manipulation and you have to do it in code or with SQL

I also found an abobe air app works fine for 2 columns
http://www.adobe.com/cfusion/marketplace/index.cfm?event=marketplace.publisher.detail&marketplaceid=1&publisherid=11144

This is a smashing tool old chap.

Much thanks n stuff given!!
 
Back
Top