In excel cell should allow only alphabets validation require

Occasional Contributor
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
5 Replies

@Rakesh891 

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

@Rakesh891 

Is a custom VBA function acceptable?

We have to do that with data valiadation only