R: function - find first number in row 0, return cell column number
 

maybe I did not understand, try for only numbers:
=MIN(IF(1:10,COLUMN(1:1)))

and with text value:
=MIN(IF((1:10)*ISNUMBER(1:1),COLUMN(1:1)))
regards
r