Restrict special character in cell

[spycein]

Hello Everyone,
I am looking for a way to not allowed "&" character in excel cell.
If i try to type "&" character then a message should pop like "Character not allowed".
Thanks in advance.
Best Regards,

 

[GraH]

Try data validation =(ISERROR(SEARCH("&",$A1)))

Book1
	A
1	a
2	46546
3	try
4
5
6
7
8
9
10
11
Sheet1

Cells with Data Validation
Cell	Allow	Criteria
A1:A11	Custom	=(ISERROR(SEARCH("&";$A1)))

 

[spycein]

Try data validation =(ISERROR(SEARCH("&",$A1)))
View attachment 12971

Book1
	A
1	a
2	46546
3	try
4
5
6
7
8
9
10
11
Sheet1

Cells with Data Validation
Cell	Allow	Criteria
A1:A11	Custom	=(ISERROR(SEARCH("&";$A1)))

Thank you so much @GraH...
Solved my issue.
Best Regards,

 

[GraH]

You're welcome. Thanks for the feedback it's working.