» 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:
- Business Analysis with Microsoft Excel (2nd Edition)
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- Accounting the Easy Way
- Microsoft Outlook 2002 for Dummies
No comments have been submitted.
