| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to determine char or number?
There is a string in cell A1, which contain char or number. I would like to
return 1 if the left(A1,1) is char, or return 2 if left(A1,1) is number. Does anyone have any suggestions on how to determine char or number for the first character of string? Thanks in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine char or number?
Hi,
Try this =ISNUMBER(LEFT(A1,1)+0)+1 -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Eric" wrote: There is a string in cell A1, which contain char or number. I would like to return 1 if the left(A1,1) is char, or return 2 if left(A1,1) is number. Does anyone have any suggestions on how to determine char or number for the first character of string? Thanks in advance for any suggestions Eric |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine char or number?
Try
=LOOKUP(CODE(A1),{0,48,58,65,91,97,123},{"",2,"",1 ,"",1,""}) -- Jacob "Eric" wrote: There is a string in cell A1, which contain char or number. I would like to return 1 if the left(A1,1) is char, or return 2 if left(A1,1) is number. Does anyone have any suggestions on how to determine char or number for the first character of string? Thanks in advance for any suggestions Eric |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine char or number?
Checkout help on the below two functions
=T() =N() -- Jacob "Eric" wrote: There is a string in cell A1, which contain char or number. I would like to return 1 if the left(A1,1) is char, or return 2 if left(A1,1) is number. Does anyone have any suggestions on how to determine char or number for the first character of string? Thanks in advance for any suggestions Eric |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine char or number?
Hi Eric
This will do the trick: =IF(ISERROR(LEFT(A1,1)*1),1,2) "Eric" wrote: There is a string in cell A1, which contain char or number. I would like to return 1 if the left(A1,1) is char, or return 2 if left(A1,1) is number. Does anyone have any suggestions on how to determine char or number for the first character of string? Thanks in advance for any suggestions Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get a line under my number that is just 1 char more? | Excel Discussion (Misc queries) | |||
| FIND 1 char in cell of any 3 char =True | Excel Discussion (Misc queries) | |||
| Determine Row number | Excel Discussion (Misc queries) | |||
| 8500 cells with phone number(7 char.), wishing to add area code (10 char.) | Excel Discussion (Misc queries) | |||
| LIMIT NUMBER OF CHAR IN A COMBINE CELL | Excel Discussion (Misc queries) | |||
Linear Mode
