excel表格中如何把单元格里用逗号分割的数据单独显示在后面?答:J2用公式:=TRIM(MID(SUBSTITUTE($I2,",",REPT(" ",100)),COLUMN(A1)*100-99,100))右拉,下拉。注:本公式中分隔符逗号为全角逗号,如果是半角逗号,用下面公式:=TRIM(MID(SUBSTITUTE($I2,",",REPT(" ",100)),COLUMN(A1)*100-99,100))...
excel有多个逗号,如何快速提取数据,已尝试分列数据,但是不可行,因为数 ...答:你的原数据中间的分隔符号一定要是同一个,你图片中的逗号,部分是中文,部分是英文,在都是中文逗号的情况下,b1=IFERROR(LEFT(MID(","&$A1,FIND("+",SUBSTITUTE(","&$A1,",","+",COLUMN(A1)))+1,50)&",",FIND(",",MID(","&$A1,FIND("+",SUBSTITUTE(","&$A1,","...
excel vba 将数据用逗号分割,并插入到不同行答:代码如下:Sub aa()Dim i, j, k As Integer Dim s As String For j = 1 To 3 s = Cells(j, 1) & ","For i = 1 To Len(s) - Len(Replace(s, ",", ""))k = InStr(1, s, ",")Cells(j, i + 1) = 1 * Left(s, k - 1)s = Mid(s, k + 1, Len(s) -...
用excel公式将以逗号分隔表示的数字单独c分列函数答:非要用公式的话 A2公式 =--MID(","&$A$1&",",FIND("~",SUBSTITUTE(","&$A$1&",",",","~",ROW(1:1)))+1,FIND("~",SUBSTITUTE(","&$A$1&",",",","~",ROW(2:2)))-FIND("~",SUBSTITUTE(","&$A$1&",",",","~",ROW(1:1)))-1)下拉 ...