Bonjour
Remplaces la macro existante par celle-ci
Sub Texte_Guillemets()
Dim J As Long
Dim Pos1
Dim Pos2
For J = 1 To Range("A65536").End(xlUp).Row
Pos2 = 0
With Cells(J, "A")
Do
Pos1 = Evaluate("=FIND(""""""""," & Cells(J, "A").Address & "," & (Pos2 + 1) & ")") ' Recherche du 1er guillemet
If IsError(Pos1) Then Exit Do
Pos2 = Evaluate("=FIND(""""""""," & Cells(J, "A").Address & "," & Pos1 + 1 & ")") ' Recherche du 2ème guillemet
If IsError(Pos2) Then Exit Do
Cells(J, "B") = Cells(J, "B") & " " & Mid(.Text, Pos1 + 1, Pos2 - (Pos1 + 1))
Loop
End With
Next J
End Sub
Bonne journée