Ok guys so I have a huge list of 2,3,4 word keywords. i would to separate the 3 word keywords. is it even possible? any ideas would be appreciated.
Is there any way to fliter 3 word keywords from ahuge list of keywords?
- Thread starter cowsgonemad
- Start date
Here is a hackish solution for Excel if you can't program:
1. I'm assuming a kw list in column a, col B blank
2. Insert a blank row above the list (row 1 is blank)
3. In B2 put the formula =FIND(" ",$A2)
4. in C2 put =FIND(" ",$A2,$B2+1)
5. In D2 put =FIND(" ",$A2,$C2+1)
6. select b2,c2,d2 and drag the the bottom of the kw list (or double click on the bottom right corner)
7. select row 1
8. choose Data-> FIlter-> Auto Filter
9. on the col c dropdown choose custom-> does not equal -> #VALUE!
10. on col d dropdown choose #VALUE!
11. you are left with a list of all the 3 word kws
(there is probably aneasier way in excel, cannot think of it right now)
1. I'm assuming a kw list in column a, col B blank
2. Insert a blank row above the list (row 1 is blank)
3. In B2 put the formula =FIND(" ",$A2)
4. in C2 put =FIND(" ",$A2,$B2+1)
5. In D2 put =FIND(" ",$A2,$C2+1)
6. select b2,c2,d2 and drag the the bottom of the kw list (or double click on the bottom right corner)
7. select row 1
8. choose Data-> FIlter-> Auto Filter
9. on the col c dropdown choose custom-> does not equal -> #VALUE!
10. on col d dropdown choose #VALUE!
11. you are left with a list of all the 3 word kws
(there is probably aneasier way in excel, cannot think of it right now)
Just write a simple program in C or whatever you know.. Read from file, count the number of spaces in each line, if that's =2 , then it's a three letter keyword. Write it to a file. Hope that helps. I would write the code for you, sorry but I just had a long day.