» Searching a String for a Matching Word from another String
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Determining whether the first word from each string in column A appears within the corresponding string in the same row of column B.
Solution:
Use the IF, ISNUMBER, FIND, and LEFT functions as shown in the following formula:
=IF(ISNUMBER(FIND(LEFT(A2,FIND(" ",A2)-1),B2)),"1st Word Found","1st Word Not Found")
Book Store:
Recommended Books:
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Business Plans Kit for Dummies (With CD-ROM)
- Keys to Reading an Annual Report (Barron's Business Keys)
- Windows XP Pocket Reference
- Special Edition Using Microsoft Word 2002
No comments have been submitted.
