Hi,

I hope this has already been answered and wasn't able to find it if it was.

I am trying to extract "AS/DK/LAT1A" from the following "Julho - AS/DK/LAT1Ano1-10". Note that the Text at the front can be any month of the year, so can change in length and the text at the end is also changeable. Also the first letter of the reference "A" can be A or C (CA/UN/CEN2A). I have tried extracting based on the hyphen but am a little stuck with =MID(F2; FIND("-"; F2);11).

Really appreciate the help,