View original (French)

Removal of "0" before a number in Excel

Solved
Jeanviaz -  
Raymond PENTIER Posted messages 58545 Registration date   Status Contributeur 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 réponses

Réponse 1 / 2
PHILOU10120 Posted messages 6463 Registration date   Status Contributeur Last intervention   833
 
The formula

To put in B9

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

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