Hi Excel Experts
I am having a bit of a problem with a project. I have a list of unsorted random data, and I need to extract a certain type of invoice number.
Example
A B C
1 [ InvoiceNr12006210..Nr.12006543 CustomerNr.056321 paid ]
2 [ Invoice 12001120 CustomerNr04624 Invoice Nr12008009 ]
3 ............
4 ......
5 .... and so on.
I only need to take out invoice numbers so anything with 1200. So far I have used =MID(A1,Find("1200",A1)+0,8)
But it only gives me the first invoice number it finds. I have a feeling I should be using the "IF" fuction some way but I can't figure it out.
If anyone could help that would be amazing.
Thanks a million
I am having a bit of a problem with a project. I have a list of unsorted random data, and I need to extract a certain type of invoice number.
Example
A B C
1 [ InvoiceNr12006210..Nr.12006543 CustomerNr.056321 paid ]
2 [ Invoice 12001120 CustomerNr04624 Invoice Nr12008009 ]
3 ............
4 ......
5 .... and so on.
I only need to take out invoice numbers so anything with 1200. So far I have used =MID(A1,Find("1200",A1)+0,8)
But it only gives me the first invoice number it finds. I have a feeling I should be using the "IF" fuction some way but I can't figure it out.
If anyone could help that would be amazing.
Thanks a million