I LOVE Excel! Thank you very much, Mr. Guillett.

"Don Guillett" wrote:


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")