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?

Hi,

It looks like they are the only rows which contain single letters too, so you could filter by Text filter > Equals > ?

? will filter out the single character entries which you can then delete.


If you want to truly filter by single letter plus upper case, then I think you would have to use the advanced filter instead.

__________________
Colin

RAD Excel Blog

Thank you very much. A bit tricky here.
You've been always very helpful.