Sub Separe()
Dim tablo, i&, x$, j%
With [A1].CurrentRegion.Columns(1)
.Replace " ", "", xlPart
.Replace "-", ""
tablo = .Resize(.Rows.Count + 1) 'matrice, plus rapide, au moins 2 éléments
For i = 1 To UBound(tablo) - 1
x = tablo(i, 1)
For j = Len(x) - 1 To 1 Step -1
If IsNumeric(Mid(x, j, 1)) And Not IsNumeric(Mid(x, j + 1, 1)) Or _
Not IsNumeric(Mid(x, j, 1)) And IsNumeric(Mid(x, j + 1, 1)) Then x = Left(x, j) & " " & Mid(x, j + 1)
Next j
tablo(i, 1) = x
Next i
.Value = tablo
End With
End Sub