=GAUCHE(A2;MIN(SI(ESTNUM(STXT(A2;LIGNE($1:$255);1)*1);LIGNE($1:$255)))-1)
=GAUCHE(SUBSTITUE(A2;F2;"");CHERCHE(" ";SUBSTITUE(A2;F2;""))-1)
=SUBSTITUE(SUBSTITUE(A2;F2&G2;"");" ";"";1)
=GAUCHE(A2;MIN(5;CHERCHE(" ";A2)))&REPT(" ";5-MIN(5;CHERCHE(" ";A2)))
=SI(ESTNUM(-STXT(A2;8;1));A2;REMPLACER(A2;5;0;" "))
=SI(ESTNUM(-STXT(C2;8;1));C2;REMPLACER(C2;5;0;" "))
Function MEF$(t$)
Dim i, j
For i = 1 To Len(t)
If IsNumeric(Mid(t, i, 1)) Then Exit For
Next
For j = i To Len(t)
If Not IsNumeric(Mid(t, j, 1)) Then Exit For
Next
MEF = Application.Replace(t, i, 0, String(9 - j, " "))
End Function
=REMPLACER(A2;deb;0;REPT(" ";9-fin))
Function MEF$(t$, n As Byte)
Dim deb, fin
deb = Application.Min(5, InStr(t, " ")) + 1 'à cause des lignes 24 et 25
For deb = deb To Len(t)
If IsNumeric(Mid(t, deb, 1)) Then Exit For
Next
For fin = deb To Len(t)
If Not IsNumeric(Mid(t, fin, 1)) Then Exit For
Next
MEF = Application.Replace(t, deb, 0, String(9 - fin, " "))
If n = 1 Then MEF = Left(MEF, 5) 'colonne C
If n = 2 Then MEF = Mid(MEF, 6, 3) 'colonne D
If n = 3 Then MEF = Mid(MEF, 10, 14) 'colonne E
End Function
=MEF($A2;COLONNES($C2:C2))
=STXT(REMPLACER($A2;deb;0;REPT(" ";9-fin));CHOISIR(COLONNES($C2:C2);1;6;10);CHOISIR(COLONNES($C2:C2);5;3;14))