ExcelBanter - How to verify the first char of the string in excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to verify the first char of the string in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/120707-how-verify-first-char-string-excel.html)

Eric

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

All times are GMT +1. The time now is 09:51 PM.