满意回答
2019/08/14 17:48
B1:=TEXT(SUM(LARGE(--MID(A1,ROW($1:$5)*3-2,2),ROW($1:$5))*100^ROW($1:$5)/100),"00 00 00 00 00")ctrl+shift+回车
评论(0)
加载中...
匿名
其他回答(1)
-
其他需要利用辅助单元格：C1：=--MID(" "&$A1&" ",FIND("!",SUBSTITUTE(" "&$A1&" "," ","!",COLUMN(A$1)))+1,FIND("!",SUBSTITUTE(" "&$A1&" "," ","!",COLUMN(B$1)))-FIND("!",SUBSTITUTE(" "&$A1&" "," ","!",COLUMN(A$1)))-1)右拉复制到D1:G1B1：=TEXT(SMALL(C1:G1,1),"00")&" "&TEXT(SMALL(C1:G1,2),"00")&" "&TEXT(SMALL(C1:G1,3),"00")&" "&TEXT(SMALL(C1:G1,4),"00")&" "&TEXT(SMALL(C1:G1,5),"00")见附图：回答于 2019/08/14 17:59
相关已解决
- 1个回答20支易灵通系统下载
- 1个回答华为n来自ova14手机如360问答何删除某个人微信聊天记录1个回答有什么推荐的教围素预帝生活常识的网站吗
- 1个回答来自脑版卡顿怎么解决" target="_blank" href="http://wenda.zanchen.net/q-85858.html">开心消消乐电来自脑版卡顿怎么解决
- 1个回答微信小程序上线需要哪些步骤
- 1个回答微信小程序上线需要哪些步骤
- 1个回答word文档中一行黑色实心无法删 而且换个OFFICE版本也是在的 还会增加 救命啊
- 1个回答乙云免费云服务器" target="_blank" href="http://wenda.zanchen.net/q-85818.html">阿贝乙云免费云服务器
- 1个回答32岁不上班 家里人疏远我了 每天玩电脑 这样能快乐吗
- 1个回答C++Sl来自eepEx和Slee360问答p函数有啥区别
0人关注该问题