如题所述
在前面空还是后面空?
Private Sub Worksheet_Change(ByVal Target As Range)
Target = Trim(Target.Value)
End Sub