UC知道EXCEL 截取字符
来源：百度知道 编辑：UC知道 时间：2024/05/11 16:04:50
A列中的数据为:
Private NAME As String
Private CD As Integer
Private SEX As String
Private CLASS As String
Private SCHOOL As String
:
:
如何编辑公式,让B列中显示
NAME
CD
SEX
CLASS
SCHOOL
:
:
Private NAME As String
Private CD As Integer
Private SEX As String
Private CLASS As String
Private SCHOOL As String
:
:
如何编辑公式,让B列中显示
NAME
CD
SEX
CLASS
SCHOOL
:
:
假设你的A列数据在A1:A5，则在B1输入公式：
=MID(A1,FIND(" ",A1)+1,FIND(" ",A1,10)-FIND(" ",A1)-1)
然后把该公式复制直到A5。
在B1里输入下面公式
=LEFT(MID(A1,(1+SEARCH(\" \",A1)),LEN(A1)-(1+SEARCH(\" \",A1))+1),SEARCH(\" \",MID(A1,(1+SEARCH(\" \",A1)),LEN(A1)-(1+SEARCH(\" \",A1))+1))-1)