excel表格怎么把字符分开

1.excel如何实现字符串拆分

可以利用VBA和正则表达式，编写自定义函数

Function SplitString(vStr As String, vType As Integer) As String

With CreateObject("VBScript.RegExp")

If vType = 1 Then '将数字置换为空，提取非数字

.Pattern = "\d" '数字

ElseIf vType = 0 Then '将非数字置换为空，提取数字

.Pattern = "\D" '非数字

End If

.Global = True

SplitString = .Replace(vStr, "")

End With

End Function

然后在单元格中插入该函数即可