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

发布网友

我来回答

共1个回答

热心网友

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

热心网友

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

热心网友

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