In excel cell should allow only alphabets validation require

[Rakesh891]

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

[#2]

@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)

[#3]

Thanks but can u please make this formula short?? Means i want very short code

[#4]

@Rakesh891 

Is a custom VBA function acceptable?

[#5]

We have to do that with data valiadation only

[#6]

@Rakesh891