|
|
#10
11-06-2015, 07:44 AM
|
||||
|
||||
If it's only the first two characters you want to check, and the data is in column A, in another column type:
=OR(EXACT(LEFT(A1,2),"E"&CHAR(64+ROW(INDIRECT("1:2 6"))))) and press Ctrl+Shift+Enter and then fill down. Now filter that column for TRUE, and delete the visible rows. (or filter for FALSE and copy visible data to a new sheet) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Why are message header rules are case sensitive | delboy | Outlook | 1 | 10-10-2023 11:30 AM |
| Help with Case and Select case | brent chadwick | Word VBA | 34 | 10-18-2015 02:13 PM |
| Deleting grid lines but keeping the axis lines | CoffeeNut | Excel | 0 | 04-01-2013 01:50 PM |
| Case Sensitive (contains) Selection | apolloman | Excel | 2 | 07-12-2011 04:50 AM |
 From all UPPER CASE to Proper Case
|
davers | Word | 1 | 04-30-2009 12:41 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode