View Single Post
Old 10-14-2010, 03:11 PM  
Adraco
Confirmed User
 
Adraco's Avatar
 
Industry Role:
Join Date: May 2009
Location: Onboard an airplane around the globe
Posts: 3,737
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.
__________________
----------------------------------------------------------------------------------
The truth is not affected by the beliefs, or doubts, of the majority.
Adraco is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote