HI I am trying to put data validation on cells in excel so it checks whether they have ".com" OR ".co.uk" i.e. they are validish web addresses. I can get it to work for one by doing this in the custom validation field
=ISNUMBER(FIND(".com",H3))
but I have tried variations of using OR but I can't get it to work, An example of what I have tried is this - I am not great at custom data validation so any help appreciated!
=OR(ISNUMBER(FIND(".COM",H3),(FIND".CO.UK",H3))
Thanks
Jen
Bookmarks