hi
I was just wondering if there is a formula or a function which you can find a certain word in a sentence for example from the list below I want to find all the cells with club in them.
Arsenal Football Club
Leeds united
Manchester Football Club
Thanks
skate1991,
Assuming those example sentences are in cells A1 through A3, you can use this formula in B1 and copy down:
=COUNTIF(A1,"*club*")
If A1 contains the word club, the formula will return 1, else 0.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Try this formula:
=IFERROR(IF(FIND("Club",A1)>0,A1,""),"")
...OR
=IF(ISERROR(FIND("club",A1,1)),"","club")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks everyone
Also see this workbook for whole word only examples.
Note that FIND() is case sensitive, SEARCH() is not.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks