怎样去掉excel表格中的英文，标点符号

Sub aa()
Dim x,y,lChar,i,bb(),p,j,m
x = ActiveCell.Row
y = ActiveCell.Column
p = Len(Cells(x,y).Value)
ReDim bb(1 To p)
For i = 1 To p
bb(i) = Mid(Cells(x,y).Value,i,1)
Next
For j = 1 To p
lChar = 65536 + Val(Asc(bb(j)))
If lChar >= 45217 And lChar

温馨提示：答案为网友推荐，仅供参考

当前网址：https://verywind.cn/ee/y7v3jr3xeyj2r7xxf3.html