hat
nòt: Si karaktè an premye nan selil espesifik se yon karaktè espesyal, tanpri aplike fòmil sa a =IF(A2="","",IF(AND(CODE(LEFT(A2,1))>=48,CODE(LEFT(A2,1))<=57),"Number",IF(OR(AND(CODE(LEFT(A2,1))>=65,CODE(LEFT(A2,1))<=90),AND(CODE(LEFT(A2,1))>=97,CODE(LEFT(A2,1))<=122)),"Letter","Other"))) pou jwenn rezilta yo. Al gade nan Ekran:
eng
Note: If the first character of specified cell is a special character, please apply the following formula =IF(A2="","",IF(AND(CODE(LEFT(A2,1))>=48,CODE(LEFT(A2,1))<=57),"Number",IF(OR(AND(CODE(LEFT(A2,1))>=65,CODE(LEFT(A2,1))<=90),AND(CODE(LEFT(A2,1))>=97,CODE(LEFT(A2,1))<=122)),"Letter","Other"))) to get the results. See screenshot: