Extract first instance of two-character string between underscores

[mnyankee]

I need help writing a formula that will search a string and return the first instance of two characters only, between two underscores. Probably not explaining that well but my examples are:

abcd_ef_gh_ijkl this should return ef
abc_efgh_ijk_lm_nop this should return lm

My current formula: =MID(A2,FIND("_",A2,1)+1,FIND("_",A2,FIND("_",A2,1)+1)-FIND("_",A2,1)-1)

is only returning the characters between the first two underscores. Is there a formula that will do what I am asking?

 

[Micron]

I wish I had learned RegEx long ago. I tried but it just wouldn't sink in so I'm stuck with more code for the same thing. I think I was able to solve it with a function as I began with the first character after the first underscore so it didn't grab the first 2 characters.

 

[Peter_SSs]

Is that correctable?

To answer that question: Yes, though of course the SEARCH & REGEX ones are still a bit simpler.

25 03 06.xlsm
	A	B
1
2	abcd_ef_gh_ijkl	ef
3	abc_efgh_ijk_lm_nop	lm
4	ab_cde_fg_hi	fg
5	a_bcd_e_fg_h	fg
6	_abc_de_fg_hi	de
Find _.._

Cell Formulas
Range	Formula
B2:B6	B2	=LET(s,TEXTSPLIT(111&A2,"_"),TAKE(FILTER(s,LEN(s)=2),,1))

I asked ChatGPT before posting my question and it was nowhere near the correct solution.

That is a fairly common situation between Excel and ChatGPT.