View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default Testing positions in a cell

=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