Re: Microsoft Excel Usage Question
hmm.. this will be a little tedious what i'm about to suggest, but a good solution if there's no alternative.
1. Get a filter setup on the UPC column
2. Using the filter function, search each letter of the alphabet, "A", "B"...
3. Deselect them, then click add current selection to filter (with the UPC/header cell selected).
This will (one alphabet at a time) filter out all the rows that happen to have an alphabet within it.
Then simply copy and paste the remaining rows into a new sheet and you should (technically speaking) have all the rows where the UPC doesn't have letters within it.
Once yot get the hang of it, it wont take you more than a minute to do.
Hope that helps |