I Need to extract invoice with multiple formats, with formula

[gad3lha]

Hi friends,

I need to extract all invoices numbers from a column with differents formats, like below:

Column

F. 93005775 - ABC - DEF - 883

F. 369 - ABC - DEF - 883

PAGO F. 16317-A - ABC -

I wanna to extract just numbers with starts with "F.".

As we can see, each invoice number have differents quantity of numbers.

Thanks a lot.

 

[Marcílio_Lobão]

gad3lha, Good afternoon.

Try to use this formula:

 =TRIM(MID(A1; SEARCH("F. ";A1)+3; SEARCH("-";A1)-(SEARCH("F. ";A1)+3)))

Please, tell us if it worked as you desire.

I hope it helps.

 

[gad3lha]

gad3lha, Good afternoon.

Try to use this formula:

 =TRIM(MID(A1; SEARCH("F. ";A1)+3; SEARCH("-";A1)-(SEARCH("F. ";A1)+3)))

Please, tell us if it worked as you desire.

I hope it helps.

Thanks a lot Marcílio, worked very well.

You saved me a lot of hours in my day.

Saudações Brasileiras!!!

 

[Marcílio_Lobão]

I'm happy to have helped.

Thanks for your feedback.

Have a great day.