» 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:
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- Getting to Yes: Negotiating Agreement Without Giving In
- Word 2002: The Complete Reference
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- Marketing Plans That Work, Targeting Growth and Profitability
No comments have been submitted.
