I have a column of terms that I pasted from two text files. I have tried to remove duplicate terms from the list but have the continued problem of having some of the duplicated terms not removed. One example is the term "Adrenal hyperplasia" and the other duplicate is "adrenal hyperplasia". I have used the standard filter with the filter being "Col A = Not Empty" and have checked the buttons for "remove duplicates". I have left unchecked the button for "Case sensitive" assuming that that would allow for 'Adrenal' to be the same as 'adrenal'. However, that appears not to be working and I don't understand why. If anyone could help me understand what I am doing incorrectly, I would appreciate it. Both lists were taken from simple text files and pasted into Calc. I combined them into one long column and then tried to remove the duplicates from it. Thank you in advance. Leon -- View this message in context: http://nabble.documentfoundation.org/problem-removing-duplicate-string-in-calc-tp4092500.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted