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.


    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


    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 "Smiley" icon, below, in the bottom right corner :)

Participate now!

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