| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Checking a cell for only Alphanumerical characters
Is it possible to check that a cell only contains Alphanumerical (a-Z, 0-9)?
-- Trefor |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Checking a cell for only Alphanumerical characters
"Trefor" wrote...
Is it possible to check that a cell only contains Alphanumerical (a-Z, 0-9)? Yes. The simplest way involves using a define name, ALPHANUM defined as ={"0";"1";"2";"3";"4";"5";"6";"7";"8";"9";"A";"B"; "C";"D";"E";"F";"G";"H"; "I";"J";"K";"L";"M";"N";"O";"P";"Q";"R";"S";"T";"U ";"V";"W";"X";"Y";"Z"} and use formulas like =SUMPRODUCT(LEN(x)-LEN(SUBSTITUTE(UPPER(x),ALPHANUM,"")))=LEN(x) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Checking a cell for only Alphanumerical characters
Harlan,
Excellent thanks, did the trick just fine. -- Trefor "Harlan Grove" wrote: "Trefor" wrote... Is it possible to check that a cell only contains Alphanumerical (a-Z, 0-9)? Yes. The simplest way involves using a define name, ALPHANUM defined as ={"0";"1";"2";"3";"4";"5";"6";"7";"8";"9";"A";"B"; "C";"D";"E";"F";"G";"H"; "I";"J";"K";"L";"M";"N";"O";"P";"Q";"R";"S";"T";"U ";"V";"W";"X";"Y";"Z"} and use formulas like =SUMPRODUCT(LEN(x)-LEN(SUBSTITUTE(UPPER(x),ALPHANUM,"")))=LEN(x) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking a cell has correct formula | Excel Discussion (Misc queries) | |||
| How do I sort multiple columns of of numerical and alphanumerical. | New Users to Excel | |||
| if function checking for numerical data vs alpha characters | Excel Worksheet Functions | |||
| Checking cell for Number | New Users to Excel | |||
| cell checking | New Users to Excel | |||
Linear Mode
