Extract characters from text in cell

[ExGus]

DEU - video_PMP_deal - DE - all sites - Group M IKEA RON Pre- & Mid

INT - video_PMP_deal - IT - all sites - PHD_TTD July_July 21

Hi, I want to extract the country code from a column. In this example, it is DE and IT but is not always in the same place as people that input info adds extra spaces but the country code should appear between "-" and "-".
What's the best way to do it knowing the country code will always be two characters but might not always be in the same position.
Thanks

 

[jtakw]

Hi,

As you described, country code is Always 2 characters sandwiched between hyphens at random positions within text string,
assuming there are no other 2 character strings other than the country code, try:

Book3.xlsx
	A	B
1	DEU - video_PMP_deal - DE - all sites - Group M IKEA RON Pre- & Mid	DE
2	INT - video_PMP_deal - IT - all sites - PHD_TTD July_July 21	IT
3	DEU - video_PMP_deal - all sites - Group M IKEA RON Pre- & -DE - Mid	DE
Sheet726

Cell Formulas
Range	Formula
B1:B3	B1	=MID(SUBSTITUTE(A1," ",""),SEARCH("-??-",SUBSTITUTE(A1," ",""))+1,2)

 

[ExGus]

That is great, works perfectly, thank you so much.

 

[jtakw]

You're welcome, glad to help.