Thread
:
IF a cell contains specific text
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
IF a cell contains specific text
Look in the help index for FIND & SEARCH. Then use within an IF formula
if(0,1,2)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Christine" wrote in message
...
Is there a way to include in a formula a command that will check if a cell
contains a specific string of text? For example, if cell G4 contains "Not
mapped" (and more text), then "Disregard" will be indicated in cell C4 -
IF(G4 contains "Not mapped","Disregard","Something else")
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett