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

[marreco]

Hi
how find specific string anywhere big string?

Data	Result
TRANSPORTADORA RODONAVES - NF: 485987 CONTRATO: 154826497 CNPJ: 154878945654654	NF: 485987
TRANSP. GAMPER - CONTRATO: 1564897785 NF: 15488 CNPJ: 1564648979201	NF: 1548
VENETO TRANPORTES - CNPJ: 498755613214 CONTRATO: 545648755 NF: 48599796	NF: 77599796

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[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!!!