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
See if this can help you out: http://www.mediafire.com/?v5vn7refrg5bj5z It is an excel sheet set up to spin copy.
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.
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]
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
