» 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:
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Microsoft Office XP Step-By-Step (With CD-ROM)
- The Interpretation of Financial Statements
- Financial Statement Analysis with S&P insert card
- Keys to Reading an Annual Report (Barron's Business Keys)
No comments have been submitted.
