Extracting text value from string

[dchubbock]

I'm trying to extract the text that sits between the last underscore ('_') and the plus sign ('+'). Example string below

#TTD_textabc-xyv-cdef_DISPLAY-OCT15-UK_120x600+211458

From this i'd like to extract 120x600. The string text length can be any number of characters... i just need to extract whatever is between the last underscore and '+'

I've tried this =TRIM(MID(D2,FIND("_",D2)+1,FIND("+",D2)-FIND("_",D2)-1)) which gets me part way there, but I can't seem to get the 'REPT' function working in tandem with the FIND function. (No text to columns suggestions pleas )

Help appreciated.

[samba_ravi]

=TRIM(LEFT(SUBSTITUTE(RIGHT(SUBSTITUTE(D2,"_",REPT(" ",LEN(D2))),LEN(D2)),"+",REPT(" ",LEN(D2))),LEN(D2)))
Try this one

[dchubbock]

You beauty. Thanks Siva!