Rick, nice tip

=TRIM(MID(SUBSTITUTE(A1," - ",REPT(" ",999)),(2-3+(LEN(A1)-LEN(SUBSTITUTE(A1," - ","")))/LEN(" - "))*999-998,999))
I think this gives error, If fieldnumber > delimiter eg: 11 in the sample

I think LEFT/RIGHT may be shorter

=TRIM(LEFT(RIGHT(SUBSTITUTE(" - "&A1," - ",REPT(" ",999)),3*999),999))

Also If the fieldnumber > Total_delimiter shows as blank.