ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Checking input for alphabet (i.e. words) (https://www.excelbanter.com/excel-programming/291119-checking-input-alphabet-i-e-words.html)

Neal[_5_]

Checking input for alphabet (i.e. words)
 
Dear Most Valued Experts,

I know that to check for numeric input you us the
IsNumeric function. I want to check if the user has typed
in a word or alpha characters. Is there something similar
to the IsNumeric to check for alpha characters? Thanks in
advance.

Neal

Vasant Nanavati

Checking input for alphabet (i.e. words)
 
Not IsNumeric

will detect alpha input.

--

Vasant




"Neal" wrote in message
...
Dear Most Valued Experts,

I know that to check for numeric input you us the
IsNumeric function. I want to check if the user has typed
in a word or alpha characters. Is there something similar
to the IsNumeric to check for alpha characters? Thanks in
advance.

Neal





All times are GMT +1. The time now is 06:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com