Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to verify the first char of the string in excel?
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) |