find specific (NF:?????) string anywhere big string

[marreco]

Hi
how find specific string anywhere big string?
[TABLE="class: grid, width: 669"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Data[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]TRANSPORTADORA RODONAVES - NF: 485987 CONTRATO: 154826497 CNPJ: 154878945654654[/TD]
[TD]NF: 485987[/TD]
[/TR]
[TR]
[TD]TRANSP. GAMPER - CONTRATO: 1564897785 NF: 15488 CNPJ: 1564648979201[/TD]
[TD]NF: 1548[/TD]
[/TR]
[TR]
[TD]VENETO TRANPORTES - CNPJ: 498755613214 CONTRATO: 545648755 NF: 48599796[/TD]
[TD]NF: 77599796[/TD]
[/TR]
</tbody>[/TABLE]

 

[Special-K99]

There's probably a shorter way but this works

=MID(A1,FIND("NF: ",A1)+4,FIND(" ",A1&" ",FIND("NF: ",A1)+4)-FIND("NF: ",A1)-4)

 

[marreco]

Hi

Very good!!

Thank you very mutch!!!