Hi Guys,

Can anyone tell me how to find the furthest number to the left, in cells ED9 to EQ9?

I.e. ED9 might be N/A, EE9 might be "HELLO", EF9 may be 29. Therefore I want 29.

Thanks!