=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