i have a cell in excell that has a string of txt, more like a paragraph. and i want to serch through the string of txt in the cell to make sure there are no duplicates. How would i go about doing this? Sample cell A2, has the the txt "see the dog run. See the dog run. See the dog run." and i want to erase all but the first instance. How would i do that?