Question

怎么样把excel表同一单元格文字里面的数字删除

怎么样把excel表同一单元格文字里面的数字删除

Answer 1

选定你要删除的单元格，用“编辑”→“替换”下拉列表，在“查找内容”输入你要删除的数字。点击“全部替换”就ok

Answer 2

如果单元格多的话
按ALT+F11，插入-模块，复制下列语句
Function SplitNumEng(str As String, sty As Byte)
Dim StrA As String
Dim StrB As String
Dim StrC As String
Dim i As Integer
Dim SigS As String
For i = 1 To Len(str)
SigS = Mid(str, i, 1)
If SigS Like "[a-zA-Z]" Then
StrA = StrA & SigS
ElseIf SigS Like "#" Then
StrB = StrB & SigS
Else
StrC = StrC & SigS
End If
Next i
Select Case sty
Case 1
SplitNumEng = StrA
Case 2
SplitNumEng = StrB
Case Else
SplitNumEng = StrC
End Select
End Function
比如你的数据在A1
BI输入 =SplitNumEng(A1,3) 表示提取中文

Answer 3

可以用“编辑”→“查找”下拉列表，用“替代”或“查找”就好了啊！

Answer 4

用鼠标拉成蓝色后删除

Answer 5

选中该列,用查找替换,把数字改为空,即可!