Find string in cell

[GregDz11]

I know this should be simple, but for some reason it's not working for me. I'm trying to locate in a cell the following phrase "5. IS THIS A COMPLIANCE SERVER, IF YES ICD MUST BE PROVIDED:" in a cell that looks like this:

PLEASE COMPLETE THE FOLLOWING, ONE SERVER PER TICKET PLEASE.


1. SERVER NAME: 


2. OS (WINDOWS, AIX, LINUX):  


3. VIRTUAL OR PHYISCAL SERVER: 


4. SERVER HOSTS SOX APPLICATION?  


5. IS THIS A  COMPLIANCE SERVER, IF YES ICD MUST BE PROVIDED:  


6. OWNER NAME:

however, find("5. IS THIS A COMPLIANCE SERVER, IF YES ICD MUST BE PROVIDED:",a2) doesn't work.

Any ideas?

 

[GregDz11]

disregard.. needed to use =SEARCH()

 

[DanteAmor]

Try:

=IFERROR(IF(FIND("5. IS THIS A COMPLIANCE SERVER, IF YES ICD MUST BE PROVIDED:",A8),"Exists"),"Dont exists")

 

[sadboy309]

So try with start number :
=FIND("5.",A8)

 

[Rick Rothstein]

So try with start number :
=FIND("5.",A8)

Hoping, of course, that there is no text starting with 15. or 25. or....

 

[DanteAmor]

Or Windows 95.

 

[Phuoc]

Or try:

=IF(COUNTIF(A8,"*5. IS THIS A COMPLIANCE SERVER, IF YES ICD MUST BE PROVIDED:*"),"Exists","Dont exists")