How do I remove duplicate text in cells
Select cell range, then menu Data → More Filters → Standard Filter, for Condition select <>, from Value select Not Empty, under Options check No duplications and Copy results to, input or select a destination cell where output shall begin, OK.