How to restrict the value in the data

[Terressa]

Hi,

I want to restrict the entries in the column of the data.

For example:- In a column I want to enter only text, if any one will enter the other then text it should give the error message.

I know that it can be done through data validation but how I dont know.

Please help me to achieve.

Thanks

[jayajaya_4]

select data validation use custom
select the range
formula:- =ISTEXT(A1)