I am trying to use the IF(LEFT( function to identify cells that start with specific words. For example, I want to identify cells with "French" but not cells with "French nightlife" Right now my statement =IF(LEFT(A1,6)="french","yes","no") returns yes for all cells that start with French. Does anyone know another statement I can try so that it only identifies cells with exactly the phrase I am interested in? Thanks.
Post SEVERAL examples and tell us what results you expect.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Are you looking for cells that contain only the word "French"? If not, then you would need to build some sort of complicated exclusion into the formula.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
If you are just looking for a single word and that is all that is in the cell, you shouldn't need to use the LEFT function.
If you just put =IF(A1="French","Yes","No") this checks for an exact match to the word you want.
Maybe something like this
Enter in B1 and copy down
Formula:
Please Login or Register to view this content.
v A B C 1 French Yes French 2 French nightlife No 3 French bread No 4 5
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
That's the fancy version of this:Originally Posted by AlKey
=IF(A1="French","Yes","No")
Lol! here is less fancyThat's the fancy version of this:
=IF(A1="French","Yes","No")
Formula:Please Login or Register to view this content.
DLG415
Using the example of AlKey, Enter in B1 and copy down this formula, = IF(C5>"",IF(C5=E5,"YES","NO"),""), get the same result, of course if that is desired, or else is a sample as either the result.
trying to help
Decio, excuses, Using Google Translator
Awesome! Thanks everyone. It looks like there are a couple ways to do it.
You're welcome. We appreciate the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks