Text search
Last year, I used a handy equation that allowed me to search rows of text strings for a variety of words i.e. university, université, college, collège... and then return a text value.
=IF(SUMPRODUCT(--ISNUMBER(SEARCH(Université,$S2))),"Université","").
I had a variant where I used a search range, which allowed me more flexibility. Do you think I can replicate this no!!! Sometimes it can be infuriating to work with Excel.
Any thoughts?
Firstly your formula is over complicated.
Try =IF(ISNUMBER(SEARCH("Université",S2)),"Université","")
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Firstly your formula is over complicated.
Try =IF(ISNUMBER(SEARCH("Université",S2)),"Université","")
This also works
=IF(ISNUMBER(SEARCH("Université",S1:S5)),"Université","")
Super. Yes your formula is much cleaner. Thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks