Thread
:
Testing positions in a cell
View Single Post
#
2
Dave Peterson
Posts: n/a
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
Reply With Quote