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:
however, find("5. IS THIS A COMPLIANCE SERVER, IF YES ICD MUST BE PROVIDED:",a2) doesn't work.
Any ideas?
Code:
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?
Last edited: