Extracting text from string between delimiter X & Y

I have a text string and i need to extract between a specific number of delimiters:

A_B_C_D_E_F_G_H_I_J

For example, how can i extract "C_D_E" i.e. the text between the 2nd and 5th underscore.

Note: the letters here denote words that could be of any length.

Previously I have used this formula to extract one delimited value =TRIM(MID(SUBSTITUTE($A2,"_",REPT(" ",LEN($A2))),((2)*LEN($A2))+1,LEN($A2)))

Not sure how to adapt this though

help appreciated.

Try this ...

=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A2,"_",REPT(" ",500),5),"_",REPT(" ",500),2),500,500))

Love it!

Thank you!

You are welcome!