New answers tagged

0

It is because it generates an error inside the OR, making OR failing to evaluate. Also, you should use AND. Try this: =AND(ISERROR(FIND("&",A1)),ISERROR(FIND("^",A1))) Using AND, because ISERROR will be TRUE if the char is NOT FOUND. and(notA,notB) = not(or(A,B)) so if A=true means & is found, and B=true means ^ is found, I believe you ...


0

I have tried something similar to what you are going after. There are unfortunately no excel formulas to return the embedded URL of a cell. The only way to retrieve this is through VBA. You will have to create an event to capture whenever a cell changes that is in a certain range. That range should cover your data validation cells. Here is an example to ...



Top 50 recent answers are included