» 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:
- Not-for-Profit Accounting Made Easy
- The 22 Immutable Laws of Branding
- Marketing Plans That Work, Targeting Growth and Profitability
- Analyzing Markets, Products, and Marketing Plans
- The Financial Numbers Game: Detecting Creative Accounting Practices
- Microsoft Excel VBA Programming for the Absolute Beginner
No comments have been submitted.
