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?

=if(isnumber(-left(a1,1)),"Number","not number")



MarcusA wrote:

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?

--

Dave Peterson

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",LE FT(A1)="7",LEFT(A1)="8",LEFT(A1)="9"),"Number","Te xt")


"MarcusA" wrote in message
...
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?