第1个回答 2012-06-07
比如你A1:F100需设置有效性,以A1为活动单元格选中A1:F100区域,数据->有效性->自定义,公式=OR(AND(MAX(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))<91,MIN(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))>64),AND(MAX(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))<58,MIN(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))>47))