求解答文本提取&条件格式

q9746711

求解两个小问题，


第一，C2格子内，我想把开始，结束时间，放一个格子内，中间用至字连接。

第二，项目2得分，就是完成除以计划，乘以权重，现在要求完成率如果超过100%，也按照100%来计算得分，项目二的得分用条件公式怎么算，

感谢各位大神！！！













weibo.com/ttarticle/p/show?id=2309405097276317237261
weibo.com/ttarticle/p/show?id=2309405097276162048434
weibo.com/ttarticle/p/show?id=2309405097276023636064
weibo.com/ttarticle/p/show?id=2309405097275884961885
weibo.com/ttarticle/p/show?id=2309405097275746549845
weibo.com/ttarticle/p/show?id=2309405097275176386903
weibo.com/ttarticle/p/show?id=2309405097275033780344
weibo.com/ttarticle/p/show?id=2309405097274761150663
weibo.com/ttarticle/p/show?id=2309405097274622738770
weibo.com/ttarticle/p/show?id=2309405097274488521207
weibo.com/ttarticle/p/show?id=2309405097274329137497
weibo.com/ttarticle/p/show?id=2309405097269841231892
weibo.com/ttarticle/p/show?id=2309405097269635711220
weibo.com/ttarticle/p/show?id=2309405097268494860483
weibo.com/ttarticle/p/show?id=2309405097268176093402
weibo.com/ttarticle/p/show?id=2309405097268016709699

solextrade

[EXCEL函数与公式版：新人必读之发贴要素]
https://club.excelhome.net/thread-1461222-1-1.html
(出处: ExcelHome技术论坛)

灵犀之声

上传文件，

灵犀之声

1. c2=a2&"至"&b2

复制代码

你是那块小饼干

[EXCEL函数与公式版：新人必读之发贴要素]
https://club.excelhome.net/thread-1461222-1-1.html
(出处: ExcelHome技术论坛)

ygl417

=TEXT(A2,"yyyy年m月d日")&"至"&TEXT(B2,"yyyy年m月d日")