Bonjour,
solution via une macro
Sub test()
With Application.FileDialog(msoFileDialogFilePicker)
.Title = "ouvrir fichier texte"
.Filters.Clear
.Filters.Add "text file", "*.txt"
.AllowMultiSelect = False
If .Show = -1 Then
fn = .SelectedItems(1)
End If
End With
Open fn For Input As 1
i = 2
Line Input #1, l
While Not EOF(1)
If l <> "" Then
If Mid(l, 2, 1) Like "#" Or Mid(l, 2, 1) = "," Then
Else
Cells(i, 1) = Replace(l, """", "")
i = i + 1
End If
End If
Line Input #1, l
Wend
Close 1
Range(Cells(2, 1), Cells(i, 1)).TextToColumns DataType:=xlDelimited, textqualifier:=xlTextQualifierDoubleQuote, comma:=True, ConsecutiveDelimiter:=True
End Sub