[已解决]字符串条件索引

29004058 · 发表于 2017-3-4 18:58

A1=cc1,,558304.090,3163518.575,332.086 要求A2=cc1；A3=3163518.575；A4=558304.090；A5=332.086
条件限制：cc1不固定位数，为变数，“，，”2个，后面三组数字不固定，“，”作为分隔符号有

最佳答案

心正意诚身修

2017-3-4 21:56

=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A1,",,",","),",",REPT(" ",99)),COLUMN(A1)*99-98,99))

砂海 · 发表于 2017-3-4 20:17

用函数比较繁琐
数据 > 分列 > 以符号 ,

心正意诚身修 · 发表于 2017-3-4 21:56

=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A1,",,",","),",",REPT(" ",99)),COLUMN(A1)*99-98,99))

		自动登录	找回密码
密码			注册