大徐哥,再次求助!!如何在EXCEL中提取文本最后一个逗号后面的内容?答:如果只有一个逗号,用楼上的公式,也可以用这个公式 =MID(TRIM(A1),FIND(",",TRIM(A1))+1,LEN(TRIM(A1)))否则用下面的公式 =MID(TRIM(A1),FIND("$",SUBSTITUTE(TRIM(A1),",","$",LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1),",","")))+1,LEN(TRIM(A1)))另外,如果字符串中,没有...
怎样取excel一个单元格中两个逗号中间的部分??答:取第一位公式:=LEFT(A1,FIND(",",A1)-1)取第二位公式:=MID(A1,FIND(",",A1)+1,FIND("*",SUBSTITUTE(A1,",","*",2))-FIND(",",A1)-1)取第三位公式:=MID(A1,FIND("*",SUBSTITUTE(A1,",","*",2))+1,FIND("*",SUBSTITUTE(A1,",","*",3))-FIND("*",SUBSTITUTE(...
excel表格中如何把单元格里用逗号分割的数据单独显示在后面?答:J2用公式:=TRIM(MID(SUBSTITUTE($I2,",",REPT(" ",100)),COLUMN(A1)*100-99,100))右拉,下拉。注:本公式中分隔符逗号为全角逗号,如果是半角逗号,用下面公式:=TRIM(MID(SUBSTITUTE($I2,",",REPT(" ",100)),COLUMN(A1)*100-99,100))...