I have an Excel sheet that I need to do some custom filtering, here's what I am trying to do:
I have a report that has specific data in Column A, In column D I have stacks of numbers in each cell that are associated with the number in Column A.
I am trying to remove the sets of numbers from Column D that I don't need. The easiest was to separate these is by number of characters. The numbers I need to keep are US####### (US and 7 digits).
I have tried filtering, and it only reads the first number in a cell, if it doesn't meet the filter it's not shown. Even if the number below it (in the same cell) matches the filter.
So here is the big question: How do I tell Excel to look in column D and only keep all instances of US#######, while removing anything else. And doing do to the entire cell, not just the first entry of the cell.
I hope I made sense, my brain hurts at this point!