Sub Remplir()
Application.DisplayAlerts = False
With [A5].CurrentRegion
.Columns(1).TextToColumns .Cells(1, 3), xlDelimited, Space:=True 'commande Convertir
.Columns(3).Replace "M.", "Mr."
.Columns(6) = "=RC[-2]&"" ""&RC[-1]"
.Columns(7) = "=RC[-2]&"" ""&RC[-3]"
.Columns(8) = "=LOWER(RC[-2])"
.Columns(6).Resize(, 3) = .Columns(6).Resize(, 3).Value 'supprime les formules
End With
End Sub