Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-11-2011, 12:55 AM
tinfanide tinfanide is offline Custom Text Filter for this particular case Windows 7 64bit Custom Text Filter for this particular case Office 2010 32bit
Expert
Custom Text Filter for this particular case
 
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
 

Tags
filter

Thread Tools
Display Modes


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
Custom Text Filter for this particular case Colorize custom footer text? markg2 Excel 2 05-25-2011 05:42 PM
Custom Text Filter for this particular case 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:27 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft