Excel MID() but counting from Right

Hi All

I have below text string where the number in the end always is 12 characters long. But the rest of the string can vary in length.
However there will also always be three "-".

40647-Access-Kim the kid-060519210519

I need a formula that extract the first 6 characters of the number in the end, so the result should be 060519.

Can anyone help here?

All help appreciated.

Regards
Stefan

Never mind.

Found this formula, and it did the trick!

=MID(A1;FIND(CHAR(1);SUBSTITUTE(A1;"-";CHAR(1);3))+1;6)