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/120706-re-how-verify-first-char-string-excel.html)

Teethless mama

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

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