![]() |
|
|
|
#1
|
|||
|
|||
|
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? |
| 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 |