User Profile
harpbelle
Copper Contributor
Joined Apr 20, 2021
User Widgets
Recent Discussions
There should be functions for testing if text string only contains alphabets
Hi, I'm using a Validation formula that checks if a given text string contains only alphabets. https://exceljet.net/formula/data-validation-specific-characters-only https://www.excelforum.com/excel-general/933361-list-of-cells-in-excel-which-will-allow-only-alphabets.html Even though they work somewhat, they rely on generation of arrays and sometimes Data Validation doesn't work the way it should. My feedback (actually complaint) to Microsoft is that there should be such functions to begin without using VBA with given how often they are used. ISALPHA() - check if given text string has only alphabets A-z, a-z ISUPPERALPHA() - check if given text string has only upper case alphabets A-Z ISLOWERALPHA() - check if given text string has only lower case alphabets a-z ISTEXT() doesn't work for my case because it can include special characters (e.g.!@#%^&*) and numbers mixed with alphabets. Even if I could declare a UDF, it probably will not work in Validation.2.6KViews0likes0Comments
Recent Blog Articles
No content to show