I am stuggling to combine two data validation conditions I want Firstname and Surname both to start with a capital letter with a space between and no punctuation except a hyphen e.g. Albert Einstein
Both these formulas work independantly
1st '=AND(ISNUMBER(FIND(" ",A1)),CODE(LEFT(A1,1))>64, CODE(LEFT(A1,1))<91, CODE(MID(A1,FIND(" ",A1)+1,1))>64,CODE(MID(A1,FIND(" ",A1)+1,1))<91)
2nd '=SUMPRODUCT(SEARCH(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1),"abcdefghijklmnopqrstuvwxyz -"))