How to ensure only alphabets letters available in the cell without numbers.

[Sekars]

Hello Friends

Is there any way only alphabets i.e., letters available in the cell except numbers (Spaces allows).

For Example. A1 = XYZ, A2 = ABC MNO, in both cells only letters with and without spaces available.

How to ensure only alphabets letters available in given cell without numbers.

thanks in advance

Sekars

[Bo_Ry]

Please try custom data validation at A1
this allow only capital letters and space
=AND((ABS(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))-77.5)<13)+(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)=" "))


this one allow all letters and space
=AND((ABS(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))-93.5)<29)+(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)=" "))

[Sekars]

Formula shows error