Good afternoon statachris

...and welcome to the forum!!
Quote Originally Posted by statachris View Post
I have a very long Excel list with text. Right now, each entry appears several times, as in say "a-a-a-f-g-g-l-m-m-m", etc, and I would like to keep each unique entry only once.
The best way to do this is probably experiment with the advanced filter (Data > Filter > Advanced Filter) and tick the box marked "Unique records only".

HTH

DominicB