Here is a general formula for obtaining the Nth field number with a user specified delimiter...

=TRIM(MID(SUBSTITUTE(A1,[Delimiter],REPT(" ",LEN(A1))),LEN(A1)*([FieldNumber]-1),LEN(A1)))

Just replace the [Delimiter] with your delimiter and [FieldNumber] with the numerical position (1 being the field in front of the first delimiter), then perform the indicated math (subtracting 1 from the field number). So, for the second field in a text string with dashes as the delimiter, the above formula would become...

=TRIM(MID(SUBSTITUTE(A1,"-",REPT(" ",LEN(A1))),LEN(A1),LEN(A1)))

If you know your text string will never be more than 99 characters long, you could simplify the above to this...

=TRIM(MID(SUBSTITUTE(A1,"-",REPT(" ",99)),99,99))

It the text could be longer than 99 characters, then change all the 99's to 999.