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.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!