Add leading 0 only after letters

  • I have data that looks like this: CI-1, CK-08, H-03, J-12, CM-11, B-8

    I want all the numerical characters from 1 to 9 to have 0s before them with the letters unchanged.

    ActualResult
    CI-1CI-01
    CK-08CK-08
    H-03H-03
    B-8B-08

    I am able to do this through several separated formulas (step by step; separating the letters from the numbers, adding the leading 0, concatenating them back together) however, this is taking too long to compute.

  • Quote

    FORUM ETIQUETTE

    4a.
    4b.
    4c. Please take the time to thank those who took their time to help you..

    Why? Because every single person that helps out at Ozgrid does so on their own free time. This is a free to post forum so show some gratitude. Besides, its nice to be nice and you will find that people will help you, if you help them by being a good responsible forum citizen.

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)