判斷有否大小寫字母 (12774)

C2{=IF(OR(1-ISERR(FIND(CHAR(ROW($1:$26)+{64,96}),B2))),"有字母","無")

另解=IF(EXACT(UPPER(B2),LOWER(B2)),"無","有字母")

另解=IF(SUMPRODUCT(ISNUMBER(FIND(CHAR(ROW($65:$90)),UPPER(B2)))*1)>0,"有字母"," 無")



留言