LinkBack URL
About LinkBacks
assuming a1 is cell being validated try a custom validation formula of
=AND(LEN(A1)<=30,SUM(LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),CHAR(ROW(INDIRECT("65:90"))),"")))=LEN(A1))
assuming a1 is cell being validated try a custom validation formula of
=AND(LEN(A1)<=30,SUM(LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),CHAR(ROW(INDIRECT("65:90"))),"")))=LEN(A1))
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks