Sub Test()
Dim Nomtot As String, Nom1 As String, Nom2 As String
Dim Pos As Byte
Nomtot = ActiveSheet.Name
On Error Resume Next
Pos = WorksheetFunction.Search(" ", Nomtot)
Nom1 = Mid(Nomtot, 1, Pos - 1)
Nom2 = Mid(Nomtot, Pos + 1)
Range("A1") = Nom1
Range("B1") = Nom2
End Sub