First in selection

[Arjen]

Hello,

I have this selection:
-
12345
215489996
25845598523364

This is also posible:
-
-
215489996
25845598523364

Now I want to know/select the first number. In the first case this will be
12345 and in the second 215489996.

How can I do that?

Thanks!

 

[Frank Kabel]

Hi
try the array formula
=INDEX(A1:A10,MATCH(TRUE,ISNUMBER(A1:A10),0))