LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
To remove numbers in a cell with out using the macro Vital_ar Excel Worksheet Functions 2 October 27th 09 01:45 PM
Cell to red flag duplicate numbers Bill Excel Discussion (Misc queries) 1 September 16th 07 11:14 PM
How can I remove 4 of 9 numbers from a cell for the whole column? RISXRAY Excel Discussion (Misc queries) 5 September 14th 06 05:33 PM
How do you remove duplicate phone numbers in an Excel spreadsheet Bridgette Excel Discussion (Misc queries) 1 May 25th 06 08:38 PM
remove text from cell containing numbers Tim Excel Discussion (Misc queries) 2 March 22nd 06 02:30 PM


All times are GMT +1. The time now is 05:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"