There should be functions for testing if text string only contains alphabets

%3CLINGO-SUB%20id%3D%22lingo-sub-2279496%22%20slang%3D%22en-US%22%3EThere%20should%20be%20functions%20for%20testing%20if%20text%20string%20only%20contains%20alphabets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2279496%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I'm%20using%20a%20Validation%20formula%20that%20checks%20if%20a%20given%20text%20string%20contains%20only%20alphabets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fformula%2Fdata-validation-specific-characters-only%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fformula%2Fdata-validation-specific-characters-only%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.excelforum.com%2Fexcel-general%2F933361-list-of-cells-in-excel-which-will-allow-only-alphabets.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fwww.excelforum.com%2Fexcel-general%2F933361-list-of-cells-in-excel-which-will-allow-only-alphabets.html%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEven%20though%20they%20work%20somewhat%2C%20they%20rely%20on%20generation%20of%20arrays%20and%20sometimes%20Data%20Validation%20doesn't%20work%20the%20way%20it%20should.%20My%20feedback%20(actually%20complaint)%20to%20Microsoft%20is%20that%20there%20should%20be%20such%20functions%20to%20begin%20without%20using%20VBA%20with%20given%20how%20often%20they%20are%20used.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EISALPHA()%20-%20check%20if%20given%20text%20string%20has%20only%20alphabets%20A-z%2C%20a-z%3C%2FP%3E%3CP%3EISUPPERALPHA()%20-%20check%20if%20given%20text%20string%20has%20only%20upper%20case%20alphabets%20A-Z%3C%2FP%3E%3CP%3EISLOWERALPHA()%20-%20check%20if%20given%20text%20string%20has%20only%20lower%20case%20alphabets%20a-z%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EISTEXT()%20doesn't%20work%20for%20my%20case%20because%20it%20can%20include%20special%20characters%20(e.g.!%40%23%25%5E%26amp%3B*)%20and%20numbers%20mixed%20with%20alphabets.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEven%20if%20I%20could%20declare%20a%20UDF%2C%20it%20probably%20will%20not%20work%20in%20Validation.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2279496%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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-alphabe...

 

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.

0 Replies