Hello Experts,
I'm trying to use MID and FIND to extract strings between the most right "ABC" and tailing "CBA" but failed. Sample file attached. Each string may have more than one "ABC" string. The goal is to find the most right one and then extract the strings between it and the tailing "CBA". I tried to use MID and FIND functions but failed.
Any suggestion is greatly appreciated.

I'm trying to use MID and FIND to extract strings between the most right "ABC" and tailing "CBA" but failed. Sample file attached. Each string may have more than one "ABC" string. The goal is to find the most right one and then extract the strings between it and the tailing "CBA". I tried to use MID and FIND functions but failed.
Any suggestion is greatly appreciated.

Attachments
Last edited: