Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
To remove numbers in a cell with out using the macro | Excel Worksheet Functions | |||
Cell to red flag duplicate numbers | Excel Discussion (Misc queries) | |||
How can I remove 4 of 9 numbers from a cell for the whole column? | Excel Discussion (Misc queries) | |||
How do you remove duplicate phone numbers in an Excel spreadsheet | Excel Discussion (Misc queries) | |||
remove text from cell containing numbers | Excel Discussion (Misc queries) |