Excel: referencing a portion of file name only

Question

Please help, i'm looking to reference a portion of my file name in an excel cell, see below example:

File name: 000_XYZ_ABC_DEF ; I need to reference the ABC portion (but this won't be limited to only 3 letters as this varies) - is there a formula I could use that would cater for the variance as well as only referencing this portion?

thank you

Answer 1

In B1, formula copied down :

=TRIM(LEFT(RIGHT(SUBSTITUTE(A1,"_",REPT(" ",30)),60),30))