#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
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. |
#3
|
|||
|
|||
Thank you very much. A bit tricky here.
You've been always very helpful. |
Tags |
filter |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
VBA to word-wrap text in a Custom Report | OTPM | Project | 2 | 03-08-2013 09:12 AM |
Case Sensitive (contains) Selection | apolloman | Excel | 2 | 07-12-2011 04:50 AM |
Colorize custom footer text? | markg2 | Excel | 2 | 05-25-2011 05:42 PM |
From all UPPER CASE to Proper Case | davers | Word | 1 | 04-30-2009 12:41 PM |
Upper to lower case | jd | Excel | 1 | 04-28-2006 07:40 AM |