» Find if a character is in a range in Microsoft Excel
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
The following characters appear in cell A1:A4
The search term we are searching for is the question mark - ?
Enter the following formula in cell B1: =SUMPRODUCT(ISNUMBER(SEARCH("~?",A1:A4))+0)>0
The result: True
Book Store:
Recommended Books:
- Microsoft Outlook 2002 for Dummies
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Microsoft Windows XP Inside Out
- Special Edition Using Microsoft Access 2002
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
Reply: Excel 95 Formula.Find - Peter Earl from Australia wrote on September 5, 2003 12:58 AM EST
Alan Posted on: 31-12-1969
Hi Peter,
My approach would be to search for 'T10' and also search for 'T100', then use a formula to check for occurances of one without the other.
HTH,
Alan.



Cheers - Pete