Read a specific 18 numbers.

[lu1zuk]

I have a excel with a line with multiples numbers in pairs of 18 and a ",(space)" then the next 18 numbers

like this
"869353363609899039, 869353363609899040, 869353363609899044, 869353363677020214, 869353363769290771, 869353363807010852, 869353363815411754, 869353363815411756, 869353363815411760, 870079612863012956, 870330472213921883, 869353363609899038"

but with like 10 or more pairs of 18 numbers.
I want to found a specific pair of 18 numbers. Tryed EXT.T with Localizar(the finding comand, sorry i use EXCEL in PT.BR so i dont know some comands name in the actual english).

And not only 1 pair, but a specific kind of pairs like

869353363815411760 = aspirante
869353363815411761 = 2 tenente
869353363823816714 = 1 tenente
and like more 8 pairs.

ATENTION: in this cell with multiple pairs of 18, it will only have one of thoses i want to find
so yes, if one cell has the aspirante pair, it won't have the 2tenente pair

What would be your's suggestions? Tryed with the ext.t and localizar(finding comand) like this

=EXT.TEXTO(d3;1;LOCALIZAR("869353363815411760";d3))

but about the (d3;1) i know this 1 number is about the number from what "location" it will start the extraction , like 1 it will skip the first(literally just 1 number) and etc
then i thought that i would need another kind of finding/extract way, tryed google but yeah.. im here trying again ;-; help please.

 

[Marcelo Branco]

luzuk

Welcome to Mr Excel forum

Here on the Mr Excel forum there is a forum for non-English questions
"Questions in other languages"

Put your question there in Portuguese, show some examples along with the desired results. I will try to help you.

M.

 

[lu1zuk]

i did it right know, thanks for the info

 

[lu1zuk]

luzuk

Welcome to Mr Excel forum

Here on the Mr Excel forum there is a forum for non-English questions
"Questions in other languages"

Put your question there in Portuguese, show some examples along with the desired results. I will try to help you.

M.

i did it right know, thanks for the info
sorry i dont know how to edit a coment

 

[Peter_SSs]

See Buscando e Separados conjunto de numeros.

This thread closed.