View Single Post
 
Old 02-07-2017, 10:11 AM
jrfoley3 jrfoley3 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: May 2013
Location: Norfolk, VA
Posts: 9
jrfoley3 is on a distinguished road
Default 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...
Attached Files
File Type: xlsx number test.xlsx (9.3 KB, 9 views)
Reply With Quote