#1
|
|||
|
|||
Read Cell For number and delete dups
Given the example I have attached (the real file has 22204 lines), I want to read each cell for the occurrence of any contiguous 4 numbers. Then spit out only the 4 digit number in a separate cell (can be the same cell) and delete any duplicates. Thanks in advance... |
#2
|
|||
|
|||
Give this a shot.
Writes the numbers to column E. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook is storing read receipts and i need to delete them before being sent | Ahmad Abolnasr | Outlook | 0 | 12-16-2016 06:06 AM |
Data validation,force cell to be filed with number if respective cell is not empty | nicholes | Excel Programming | 0 | 08-01-2015 09:08 AM |
Delete starting number *) and delete Unneeded data in series | frustrated teacher | Word VBA | 5 | 12-07-2014 06:53 PM |
dups | OCM | Excel | 1 | 07-13-2013 02:52 AM |
How can I delete the content of a cell in column if the cell value is more than 1000? | Learner7 | Excel | 2 | 06-27-2011 05:44 AM |