 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / May 2008If(cell) "contains" certain words...
Certainly there is a simple way to find out if a cell that has text in it contains a certain word. For example, cell A1 is populated with the words "Houston, TX, USA." In Cell A2 I want a function that can look into A1 to see if the word "Houston" is contained in there. If it is, I would have the function return a value or some other "text." If only there were a symbol for "contains" if would be a breeze. =If(A1[symbol]"Houston",1,0). Who has the answer to this? One way: =--COUNTIF(A1,"*Houston*") In article <82505b17-58c3-455c-8e6b-5477abd836fa@e39g2000hsf.googlegroups.com>, > Certainly there is a simple way to find out if a cell that has text in > it contains a certain word. For example, cell A1 is populated with [quoted text clipped - 5 lines] > If only there were a symbol for "contains" if would be a breeze. > =If(A1[symbol]"Houston",1,0). Who has the answer to this? Another way: =IF(ISNUMBER(SEARCH("Houston",A1)),"yes","no") SEARCH is not case sensitive - use FIND instead if you need this. Hope this helps. Pete > Certainly there is a simple way to find out if a cell that has text in > it contains a certain word. For example, cell A1 is populated with [quoted text clipped - 5 lines] > If only there were a symbol for "contains" if would be a breeze. > =If(A1[symbol]"Houston",1,0). Who has the answer to this? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.