Hi,

I need a formula that will find the position of the first number in a string, and how many characters are in that number. For instance, it should return 2 and 6 for the value below.

T106300 7/14-7/15/16 GRT DEAN

I found this formula to get the position of the first number: =MIN(IF(ISNUMBER(FIND({0,1,2,3,4,5,6,7,8,9},A1)),FIND({0,1,2,3,4,5,6,7,8,9},A1)))

I need help with the second part.

Thanks for your help,

Craig