» Searching a String for a Specific Substring
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Problem:Checking whether each of the substrings in column A exist in the corresponding strings from the same row of column B.
Solution:
For case sensitive results: Use the ISNUMBER and FIND functions as shown in the following formula:
=ISNUMBER(FIND(A2,B2))
For case insensitive results: use the SEARCH and LEN functions as shown in the following formula:
=SEARCH(A2,B2&A2)
Book Store:
Recommended Books:
- Fish! A Remarkable Way to Boost Morale and Improve Results
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Microsoft Word Version 2002 Inside Out
- Business Analysis with Microsoft Excel (2nd Edition)
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
No comments have been submitted.
