Testing positions in a cell

M

MarcusA

I need to determine whether first character in a cell is either a text or
numeric value. How can I do this using a function command?
 
M

Mladen_Dj

Function:

=ISNUMBER(VALUE(LEFT(A1)))

Will return TRUE if first character in cell is numeric value, otherwise
returns false.
Another way (gives you "Text"/"Number" output):

=IF(OR(LEFT(A1)="0",LEFT(A1)="1",LEFT(A1)="2",LEFT(A1)="3",LEFT(A1)="4",LEFT(A1)="5",LEFT(A1)="6",LEFT(A1)="7",LEFT(A1)="8",LEFT(A1)="9"),"Number","Text")
 
Top