Hi, is there an easy way to remove duplicate text in a cell? For example:

Cell A1: Ford, Dodge, Ford,
Answer required is Ford, Dodge,

Can someone give me a formula to accomplish this, it seems so easy.

Thanks