Dec 29 2021 10:12 PM
Dec 30 2021 12:42 AM
Let's say you want to apply this to the range A1:A100.
Select this range. A1 should be the active cell in the selection.
Create a data validation rule of type Custom with formula
=SUMPRODUCT((CODE(UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))>=65)*(CODE(UPPER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))<=90))=LEN(A1)
Dec 30 2021 12:49 AM
Dec 30 2021 03:03 AM
Is a custom VBA function acceptable?
Dec 30 2021 03:05 AM