GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Excel question

mkx · 10-14-2010, 02:44 PM

I want to eliminate duplicate words in excel. Let's say I have column A1 that reads =

John thinks pizza pizza is better than pappa john

Excel will automatically rewrite it in Column B1 =

John thinks pizza is better than pappa

It needs to be a universal formula because it's not just pizza and john that is duplicated, got about 10,000 rows of data with duplicate words and I am working on a keyword list with limited length allowance.

Hope someone can help, I asked my friend and google, and they are smart but they couldn't help.

10-14-2010, 02:44 PM
mkx Confirmed User Industry Role: Join Date: Nov 2003 Location: Toronto Posts: 4,001	Excel question - removing duplicate words I want to eliminate duplicate words in excel. Let's say I have column A1 that reads = John thinks pizza pizza is better than pappa john Excel will automatically rewrite it in Column B1 = John thinks pizza is better than pappa It needs to be a universal formula because it's not just pizza and john that is duplicated, got about 10,000 rows of data with duplicate words and I am working on a keyword list with limited length allowance. Hope someone can help, I asked my friend and google, and they are smart but they couldn't help.