Dear experts,
I have the following formula:
=FIND("(",Sheet1!$A12,1)
What I would like is to include "[" and "/" as the FIND criteria as well.
I tried
=FIND({"(","[","/"},Sheet1!$A12,1)
with no luck.
I understand that excel will get confused if at least two of the criteria are present in the string but this is not the case in my data.
Thanks in advance.
Zealot
I have the following formula:
=FIND("(",Sheet1!$A12,1)
What I would like is to include "[" and "/" as the FIND criteria as well.
I tried
=FIND({"(","[","/"},Sheet1!$A12,1)
with no luck.
I understand that excel will get confused if at least two of the criteria are present in the string but this is not the case in my data.
Thanks in advance.
Zealot