Quote:
Originally Posted by Adraco
There might be a more direct way in Excel that I do not know of, but this is how I would solve it, quick and dirty:
Export all to a comma separated file.
Search and replace all "spaces" by a comma.
Import into Excel, with each word in it's own column.
Then do some IF conditions, IF B1=A1; "then delete B1" ELSE leave B1 as is and proceed to C1.
|
This sort of thing is what I'd suggest. One thing you can do if you need to review all the cases instead of simply delete any such case is to have an etra column do all the checks with "STOP" if it finds a dupe and blank if it doesn't. You can then copy the column and paste in only values, and then starting from the top, if you hit end and then down, you'll go to the next "STOP", check/fix it and delete the "STOP", rinse and repeat until there's no more "STOP"s. Just suggesting that since there are actual cases in grammar when words can be repeated, in which case an automatic fix will have just screwed the sentence.