Hello,
Using Office 2007 and trying to find word in cells.
I have to find all the cells that contain the word JOS and put the word JOS in another cell.
Cell B1 contains: Procedures for Clearing (JOS 6-G)
so I want C1 to put now contain JOS for easy sorting.
Thanks for your help on this.
Bruce
=IF(COUNTIF(B1,"*"&"JOS"&"*")>0,"JOS","")
or
=IF(ISNUMBER(SEARCH("jos",B1)),"JOS,","")
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Worked perfectly.
Thank you.
Why does it work with =IF(ISNUMBER
That seems strange.
If that takes care of your original question, please select Thread Tools from the menu link just above your first post and mark this thread as SOLVED.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
SEARCH(find what, where) returns the starting position of what it finds.
=SEARCH("bert", "robert") = 3 because "bert" appears beginning at the third character.
=SEARCH("bert", "william") = error, because it doesn't find it.
Therefore, ISNUMBER(SEARCH()) returns true if it finds it, and false if it doesn't.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks