One of the data validation challenges is prevent the users from entering special characters in text field (Single line of text) . In this validation formula, nested if & isError will be used as in the following formula
=AND(IF(ISERROR(FIND(“,”,[ColumnName])),TRUE), IF(ISERROR(FIND(“&”,[ColumnName])),TRUE), IF(ISERROR(FIND(“;”,[ColumnName])),TRUE), IF(ISERROR(FIND(“[“,[ColumnName])),TRUE), IF(ISERROR(FIND(“+”,[ColumnName])),TRUE), IF(ISERROR(FIND(“:”,[ColumnName])),TRUE), IF(ISERROR(FIND(“)”,[ColumnName])),TRUE), IF(ISERROR(FIND(“-“,[ColumnName])),TRUE), IF(ISERROR(FIND(“*”,[ColumnName])),TRUE), IF(ISERROR(FIND(“(“,[ColumnName])),TRUE), IF(ISERROR(FIND(“$”,[ColumnName])),TRUE), IF(ISERROR(FIND(“%”,[ColumnName])),TRUE), IF(ISERROR(FIND(“~”,[ColumnName])),TRUE), IF(ISERROR(FIND(“#”,[ColumnName])),TRUE), IF(ISERROR(FIND(“]”,[ColumnName])),TRUE), IF(ISERROR(FIND(“.”,[ColumnName])),TRUE), IF(ISERROR(FIND(“!”,[ColumnName])),TRUE), IF(ISERROR(FIND(“@”,[ColumnName])),TRUE), IF(ISERROR(FIND(“/”,[ColumnName])),TRUE), IF(ISERROR(FIND(“\”,[ColumnName])),TRUE))
Also, the same formula can be used to prevent numeric values to be entered in the text field and replacing the characters with the numbers.
I hope this will be helpful for the SharePoint developers.
Enjoy single line of text without special characters
Im thankful for the article post. Much thanks again. Really Great. Louise Cecilio Lynelle
Simply wanna comment that you have a very nice internet site, I like the layout it really stands out. Lizzy Moss Mientao
Thanks
Make sure you utilize tags in your blog posts in a careful manner. Hedwig Hamid Eads
Thank you for the advice
Rattling nice style and fantastic written content , practically nothing else we require : D. Angelle Chickie Davidoff
Thanks
Way cool! Some extremely valid points! I appreciate you writing this post and the rest of the website is very good. Brina Westley Genevra
Thanks
I think this is a real great article. Thanks Again. Keep writing. Gretal Walton Gotthard
Thanks
I appreciate, cause I found exactly what I was looking for. You’ve ended my 4 day long hunt! God Bless you man. Have a nice day. Bye
Thanks
I am not sure where you are getting your information, but good topic. Jess Nolly Roosevelt
This is the solution I did and it worked so I am sharing it.
Thanks
Fantastic web site. Lots of helpful information here. I am sending it to a few friends ans also sharing in delicious. And certainly, thanks in your effort! Andromache Vinnie Alick
Awesome read. I just passed this onto a buddy who was doing some research on that. He actually bought me lunch because I found it for him! Thus let me rephrase: Thank you for lunch! Fredra Bennie Lari
Hi there. I found your website via Google even as searching for a comparable topic, your web site came up. It appears good. I have bookmarked it in my google bookmarks to visit then. Henrie Alaric Zipnick