=SUBSTITUE(SUBSTITUE(STXT(SUBSTITUE($A2;"-";"");EQUIV(E$1&"=";STXT(SUBSTITUE($A2;"-";"");LIGNE($1:$255);NBCAR(E$1)+1);0)+NBCAR(E$1)+2;3);"/";"");"""";"")
[FONT=Verdana][FONT=Verdana]=SUBSTITUE(SUBSTITUE(SUBSTITUE(STXT($A2;TROUVE(E$1&"=";$A2)+NBCAR(E$1)+2;3);"""";"");"/";"");"-";"")*1[/FONT]
[/FONT]
Sub Macro1()
Application.ScreenUpdating = False
With Sheets("Feuil1")
.Columns("C:F").ClearContents
.Columns("A:A").Copy .Range("B1")
With .Columns("B:B")
.Replace What:="°", Replacement:=";", LookAt:=xlPart
.Replace What:="'", Replacement:=";", LookAt:=xlPart
.Replace What:="""", Replacement:=";", LookAt:=xlPart
.TextToColumns Destination:=Range("C1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _
Semicolon:=True, Comma:=False, Space:=False, Other:=False, FieldInfo _
:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1)), TrailingMinusNumbers:= _
True
.ClearContents
End With
End With
Application.ScreenUpdating = True
End Sub
=GAUCHE(A4;TROUVE("°";A4)-1)*1
=STXT(A4;TROUVE("°";A4)+1;TROUVE("'";A4)-TROUVE("°";A4)-1)*1
=STXT(A4;TROUVE("'";A4)+1;TROUVE("""";A4)-TROUVE("'";A4)-1)*1
=DROITE(A4)
Cherches encore ...Qui cherche trouve....
=SUPPRESPACE(GAUCHE(A4;CHERCHE("°";A4)-1))*1
=STXT(A4;CHERCHE("°";A4)+1;-1+CHERCHE("'";A4)-CHERCHE("°";A4))*1
=SUBSTITUE(SUBSTITUE(GAUCHE(DROITE(A4;7);5);"'";"");".";",")*1
=DROITE(A4)