A way to eliminate repeated info within a cell

[Guest]

I'm downloading information from a database and everything in one of the
fields is duplicated. I would like a formulate or filter to eliminate the
duplicate.

 

[Tom Ogilvy]

See Chip Pearson's page on this

http://www.cpearson.com/excel/duplicat.htm

 

[oldchippy]

Try this it will find duplicates

Sort your data by the column with the duplicates in, insert a column
next to it and put something like this,

formula in B1

=IF(A1=A2,"duplicate","") and copied this down to the end - this says
if A1 is the same as A2 mark it as "duplicate" otherwise put "blank"

Alter cell ref to suit

oldchippy