I am doing the scanning of an identity document, but when it does it adds two zeros to the beginning of the document in column (N° Cédula),
I am trying to remove those two zeros with the SUBSTITUTE formula but it also removes the two zeros that are after the “8”, I tried with the formula LEFT tell it to only remove the first two zeros from the beginning but it doesn’t work, do you know how I can improve the formula?
User | Count |
---|---|
41 | |
35 | |
27 | |
23 | |
16 |