Bet you don't know this answer!!

Scotland · Jul 21, 2010

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

BassTrackerBoats · Jul 21, 2010

See if this can help you out:

http://www.mediafire.com/?v5vn7refrg5bj5z

It is an excel sheet set up to spin copy.

loclhero · Jul 21, 2010

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.

AtomBoy · Jul 21, 2010

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.

Chronos · Jul 21, 2010

loclhero said:
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?

Scotland · Jul 21, 2010

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?

AtomBoy · Jul 21, 2010

what's the site?

Scotland · Jul 21, 2010

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

bertbaby · Jul 21, 2010

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]

Scotland · Jul 21, 2010

bertbaby said:
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!!

essares1 · Jul 21, 2010

Send me the list. I will create 50x50x50x50 lines and send it to you. How I do it? I program it.

3gpstreet · Jul 21, 2010

Use black coffee and Excel formula to combine the sells and rows

AtomBoy · Jul 21, 2010

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/market...sher.detail&marketplaceid=1&publisherid=11144

Scotland · Jul 21, 2010

AtomBoy said:
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!!

Bet you don't know this answer!!

Scotland

Regular Member

BassTrackerBoats

Support Admin

loclhero

Supreme Member

AtomBoy

Junior Member

Chronos

Junior Member

Scotland

Regular Member

AtomBoy

Junior Member

Scotland

Regular Member

bertbaby

Elite Member

Scotland

Regular Member

essares1

Junior Member

3gpstreet

Newbie

AtomBoy

Junior Member

Scotland

Regular Member

Main Menu

Marketplace

Making Money

BlackHatWorld

Other