Find Function

[mariolos]

hello to all

I have the following:

AGUA LUN I 101 ANTOFAGASTA 1568 JOSE CODOCEO
ALBERT 155 MEJILLONES 18420 JUAN ZEPEDA
ALCATRAZ 81 MEJILLONES 1310 VICTOR ESCOBAR
ALDEA II 364 MEJILLONES 900066 RAMON GARCIA
ANFIBIO 383 MEJILLONES 901225 JOSE CORTES
ANWAR 210 TOCOPILLA 18363 PEDRO ANTIQUERA
AOD 972 ANTOFAGASTA 25698 JUAN COZ
APOCALIPSIS 215 TALTAL 1057 JUAN TORRES
AQUA MAN II 1261 ANTOFAGASTA 914428 JORGE FLORES

I need find the first position numeric.

I use the following funcion
HALLAR({"1"\"2"\"3"\"4"\"5"\"6"\"7"\"8"\"9"\"0"};A12)


but in some cases the result is that I surrender mistake.

help

thx in adv.

 

[T. Valko]

Try this:

=MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))

 

[mariolos]

Try this:

=MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))

thx a lot

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

thx a lot