Sub Extraire_4()
Dim plg As Range, c As Range
Set plg = Range("A1", Range("A1").End(-4121))
For Each c In plg
c.Offset(, 1) = Left(c, PNu(c.Text) - 1)
c.Offset(, 2) = Mid(c, PNu(c.Text), 9 ^ 9)
Next
End Sub
Private Function PNu(sTr$) As Integer
For PNu = 1 To Len(sTr)
If Mid(sTr, PNu, 1) Like "#" Then Exit Function
Next
PNu = 0
End Function