Sub myleft() arr = [A1:Z1] '设置区域A1~Z1 For i = 1 To UBound(arr, 2) '进行循环 If Right(arr(1, i), 1) = " " Then 判断最后一位是否空格 Cells(1, i) = Left(arr(1, i), Len(arr(1, i)) - 1) '是否重写单元格 End If Next End Sub
sub 去空格() dim x as range dim y as range set y = application.inputbox(prompt:="选择需要去掉空格的单元格区域",type:=8) for each x in y x.value=TRIM(x.value) next end sub本回答被提问者采纳