» 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 Ernst & Young Business Plan Guide
- Business Plans Kit for Dummies (With CD-ROM)
- Writing Excel Macros with VBA, 2nd Edition
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Business Plans For Dummies®
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
No comments have been submitted.
