Forum Discussion
In excel cell should allow only alphabets validation require
Hy can u help me in doing this task. My ce should allow only alphabets ( not including number or any symbol.) with help of validation tools only
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)
Thanks but can u please make this formula short?? Means i want very short code
Is a custom VBA function acceptable?
- We have to do that with data valiadation only