Duplicate Info

[Hooter]

Hi

Is there way of removing duplicate info in the same cells

ie,

brown fox
yellow fox
brown fox
brown fox
blue fox

after action

brown fox
yellow fox
blue fox

Rgds Simon

 

[JE McGimpsey]

Check out the info on Advanced Filter (using unique values only) in XL
Help, or at

http://www.contextures.com/xladvfilter01.html

 

[Gord Dibben]

Hooter

"In the same cells" means all the foxes are in one cell?

Gord Dibben Excel MVP