Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would like to write a procedure that would test a single character in a
string contained in a worksheet cell to see if it's a number, then test another character in the same string to see if it's a letter. In this case, the string to test is located in Worksheets("dataEntry").Range("testCell") I would like to test the first character in the string in that cell to see if it's a number. I would like to test the second character to see if it's a letter. If either of these conditions returns false, I'd like the whole expression to be false. Thanks in advance. Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is the first character a number or letter | Excel Worksheet Functions | |||
testing for character strings within a cell | Excel Worksheet Functions | |||
Odd! Excel changes my letter character. Why? | Excel Discussion (Misc queries) | |||
change headers from letter to number/number to letter | Excel Worksheet Functions | |||
column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) |