» Searching a String for a Specific Substring
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
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:
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Special Edition Using Microsoft Word 2002
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- Microsoft Windows XP Step by Step (With CD-ROM)
- The Basics of Finance: Financial Tools for Non Financial Managers
No comments have been submitted.
