Custom Text Filter for this particular case
I have a large set of data like:
A
abandon
arrange
B
Bet
Bit
C
come
customise
I want to delete all the cells that contain the uppercase letters "A", "B", "C"... (there are 26 of them - in the alphabet) a long list of them
I bet it'd be somewhere in the text filter that can resolve it but I tried some combinations like
contains
begins with
ends with
with the use of "?", "*" wildcards
How can the job be done in Excel 2010?
|