A way to eliminate repeated info within a cell

[mm]

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

--
Regards,
Tom Ogilvy

"mm" <[email protected]> wrote in message
news:[email protected]...
> 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.

[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