Find and extract invoice number from text string

[fishmonger]

I am looking for a way to extract invoice number from a text string

For example in these two text string there is invoice T-123456. How can I write a formula to only extract the T-123456? Invoice number is always in the format T-six digits.
Invoice number T-123456 on December 2021
Purchase made on December 2021 invoice T-123456

Thank you

 

[Phuoc]

Like this

Book1 (1).xlsx
	A	B
1	Purchase made on December 2021 invoice T-123456	T-123456
2	Invoice number T-123456 on December 2021	T-123456
Sheet1

Cell Formulas
Range	Formula
B1:B2	B1	=MID(A1,FIND(" T-",A1)+1,8)

 

[fishmonger]

Like this

Book1 (1).xlsx
	A	B
1	Purchase made on December 2021 invoice T-123456	T-123456
2	Invoice number T-123456 on December 2021	T-123456
Sheet1

Cell Formulas
Range	Formula
B1:B2	B1	=MID(A1,FIND(" T-",A1)+1,8)

[/RANGER

Cell Formulas
Range	Formula

Like this

Book1 (1).xlsx
	A	B
1	Purchase made on December 2021 invoice T-123456	T-123456
2	Invoice number T-123456 on December 2021	T-123456
Sheet1

Cell Formulas
Range	Formula
B1:B2	B1	=MID(A1,FIND(" T-",A1)+1,8)

Thanks a lot!