Majo2469
asked on
EXCEL 2010 HOW TO REMOVE DATA BASED ON NUMBER OF CHARATERS
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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.