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


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



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