View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lucky[_6_] Lucky[_6_] is offline
external usenet poster
 
Posts: 17
Default Remove Duplicate Numbers in One Cell

My worksheet has one column in which each cell has one and two-digit
numbers separated by spaces, such as

1 18 22 5 1 31 8 11 6 1

I want to remove all the duplicate numbers in each cell, leaving only
one instance of each number in there. (1 and 11 are different
numbers, of course). I've tried a few solutions, but they're clunky
and inelegant and take a long time to do these thousands of cells.

Anyone have a better way?
Thanks,
Lucky