Return pattern of text

[mib1019]

Thanks in advance for your help. I am looking for the text function that would return a substring matching a specific pattern from cells in a table. The substring position in the text is variable (beginning, middle or end), but always the same. Here are some sample cell values in Table, column 'Search Instance' (column C of worksheet)

GNRG000885 9117/2019 .. ChaS.e Fraud: Did you use
the property owner. GNRG000908 Dan Ke , PresiJ, _ , 10A /20
Bond Number: 63528033). GNRG000001

Need to extract the text GNRGXXXXXX from each.

Thanks!
MB

 

[shift-del]

Hi MB

Assuming always length 10.

Mappe11
	A	B
1	GNRG000885 9117/2019 .. ChaS.e Fraud: Did you use	GNRG000885
2	the property owner. GNRG000908 Dan Ke , PresiJ, _ , 10A /20	GNRG000908
3	Bond Number: 63528033). GNRG000001	GNRG000001
Tabelle1

Cell Formulas
Range	Formula
B1:B3	B1	=MID(A1,SEARCH("GNRG",A1),10)

 

[mib1019]

Thanks so much!