Replace Character based on legnth

I have Employee number contain 4,5,6 digit number,I want to to convert all the employees ID with 6 Digit by using legnth 

Suppose 

If A2 Contain with 4 digit 

        E778         Replace to E00778

If A2 Contain with  5 Digit

     E2068               replace to E02068

If A2 Contain with 6 Digit 

      EW0120      then take same value 

Please solve this query 

By: Nazre Alam

Leave a Reply

Your email address will not be published. Required fields are marked *