Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to verify the first char of the string in excel?
=IF(LEFT(A1,1)="2",1,2)
"Eric" wrote: Does anyone know how to verify the first char of the string in excel? such as string in cell A1 = " 250", then in cell B1, if the first char of the cell A1 is equal to "", then return 1 elsel 2; Does anyone know how to code it in excel? Thanks & Regards Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
How do I convert char into integer in Excel VBA? | Excel Discussion (Misc queries) | |||
Multiple Excel versions. | Excel Discussion (Misc queries) | |||
How can delete the duplicate word from a string in cell in EXCEL | Excel Discussion (Misc queries) | |||
Opening CSV, How to Tell Excel String is not a Date? | Excel Discussion (Misc queries) |