excel如何用函数实现分列的功能,按特定字符分列
如
1,2,3,4,5,6,7
a,b,c,d,e,f,g
4,5,6,7,8,9,0
1,2,3,4,5,6,7
a,b,c,d,e,f,g
4,5,6,7,8,9,0
=TRIM(MID(SUBSTITUTE($A1,",",REPT(" ",99)),(COLUMN(A1)-1)*99+1,99))
每个分隔字符之间的字符位数是不一样的
怎么个不一样法,你也没说具体要求,怎么给你方案
热门标签:
如
1,2,3,4,5,6,7
a,b,c,d,e,f,g
4,5,6,7,8,9,0
1,2,3,4,5,6,7
a,b,c,d,e,f,g
4,5,6,7,8,9,0
=TRIM(MID(SUBSTITUTE($A1,",",REPT(" ",99)),(COLUMN(A1)-1)*99+1,99))
每个分隔字符之间的字符位数是不一样的
怎么个不一样法,你也没说具体要求,怎么给你方案