View Single Post
 
Old 09-11-2011, 12:55 AM
tinfanide tinfanide is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default 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?
Reply With Quote