| Home |
| Search |
| Today's Posts |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is the first character a number or letter
"Sunrays17" wrote...
i am looking forward to know is there any formula to know if a value is alphanumeric too, as well as its a number or a letter... .... Adapt some of the other formulas. Alternatively, =COUNT(SEARCH(LEFT(s,1),"0123456789ABCDEFGHIJKLMNO PQRSTUVWXYZ")) returns TRUE if the first char in s is alphanumeric, FALSE otherwise. This is easily adapted to non-English languages with more/other letters. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add number from a cell that contains a specific character | Excel Worksheet Functions | |||
| Adding a letter to the beginning of each part number of a column | Excel Discussion (Misc queries) | |||
| Count number of uniques starting with a given letter? | Excel Discussion (Misc queries) | |||
| How do I get a number or letter to represent cell contents? | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Threaded Mode
