» 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.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
Cheers - Pete