View original (French)

Removal of "0" before a number in Excel

Solved
Jeanviaz -  
Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   -
Hello,

In Excel 2007, I have a list of parcel areas in column A presented in the following form (the list contains several thousand rows):

Example:

01 ha 32 a 26 ca
06 a 45 ca
12 a 36 ca
23 ha 05 a 10 ca
07 a 03 ca

I want to eliminate the superfluous "0" at the beginning of the area to obtain in column B the areas in the following form:

1 ha 32 a 26 ca
6 a 45 ca
12 a 36 ca
23 ha 05 a 10 ca
7 a 03 ca

Do you have a solution?

Regards

Jean

Configuration: Windows Vista / Internet Explorer 8.0

2 answers

  1.
    PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   835
     
    The formula

    To put in B9

    =IF(LEFT(A9,1)="0",RIGHT(A9,LEN(A9)-1),A9)

    this example for cell A9
    2
    1. Jeanviaz
       
      Thank you "PHILOU10120", the result is what I wanted!
      0