求教各位通过EXCEL公式进行TCH频点号合并（载频数不定，各频点之间逗号相隔）

用&连接起来，再把；替换为，即可。

=TCH1;&TCH2;....&@#(_@s4fads1K:JFD()$#_*(本文来自移动通信网www.mscbsc.com,版权所有
$#$#&)*(&#K:JFD()$#_本文来自移动通信网www.mscbsc.com,版权所有
当然 上面等于号后面是tch所在的单元格
)$#@322K:JFD()本文来自移动通信网www.mscbsc.com,版权所有

用个判断  =if（TCH>0,TCH&";",“ ”）&if（……）  推下去s13东oitrK:JFD()$#本文来自移动通信网www.mscbsc.com,版权所有

excel要好好学学&#*($(哦*&#K:JFD()$#_*本文来自移动通信网www.mscbsc.com,版权所有

=TCH1&","&TCH2      然后 回车   就成了TCH1,TCH2啦~ioK:JFD()$#_本文来自移动通信网www.mscbsc.com,版权所有

如果总的频点不大于12个，频点数据分别在单元格区域A2:L2，那么在单元格M2的地方输入公式=IF(A2<>"",A2&IF(B2="","",","),"")&IF(B2<>"",B2&IF(C2="","",","),"")&IF(C2<>"",C2&IF(D2="","",","),"")&IF(D2<>"",D2&IF(E2="","",","),"")&IF(E2<>"",E2&IF(F2="","",","),"")&IF(F2<>"",F2&IF(G2="","",","),"")&IF(G2<>"",G2&IF(H2="","",","),"")&IF(H2<>"",H2&IF(I2="","",","),"")&IF(I2<>"",I2&IF(J2="","",","),"")&IF(J2<>"",J2&IF(K2="","",","),"")&IF(K2<>"",K2&IF(L2="","",","),"")&IF(L2<>"",L2,""),如果大于12个可以往下推。然后把公式往下复制即可。%kcvmmvckK:JFD()$#本文来自移动通信网www.mscbsc.com,版权所有
       下面讲解一下上面的公式IF(A2<>"",A2&IF(B2="","",","),"")第一个IF判断单元格A2是否为空，如不为空则返回A2的值，否则不返回数值;第二个IF是判断是否添加逗号“，”如果后面的单元格即B2为空时不添加，否则添加。$#@3221a3ds襅:JFD()$#_*(本文来自移动通信网www.mscbsc.com,版权所有哦*&#%kcvmmK:JFD()$#_*本文来自移动通信网www.mscbsc.com,版权所有
ds也f12dK:JFD()$本文来自移动通信网www.mscbsc.com,版权所有kcvmmvcK:JFD()本文来自移动通信网www.mscbsc.com,版权所有
哦*&#%kcvK:JFD()$#本文来自移动通信网www.mscbsc.com,版权所有4afd5a4f8eK:JFD()$#_本文来自移动通信网www.mscbsc.com,版权所有

公式：=C2&IF(D2>0,","&D2,"")&IF(E2>0,","&E2,"")&IF(F2>0,","&F2,"")&IF(G2>0,","&G2,"")&IF(H2>0,","&H2,"")21%$#(K:JFD(本文来自移动通信网www.mscbsc.com,版权所有

*($(哦*&#%kcK:JFD()$#_*(本文来自移动通信网www.mscbsc.com,版权所有

=TCH1&","&TCH2      然后 回车   就成了TCH1,TCH2是对的s4fads13东oK:JFD()$#_*本文来自移动通信网www.mscbsc.com,版权所有
vmmvckjlureK:JFD()$#_*本文来自移动通信网www.mscbsc.com,版权所有
#(*)#$@K:JFD()本文来自移动通信网www.mscbsc.com,版权所有

楼住找到答案了吗？fds3a2K:JFD(本文来自移动通信网www.mscbsc.com,版权所有

先转化成文本格式，再粘贴到EXCEL表格saf12K:JFD本文来自移动通信网www.mscbsc.com,版权所有

sailuo的答案h$#$#K:JFD本文来自移动通信网www.mscbsc.com,版权所有
fads13东oitK:JFD()$#_*本文来自移动通信网www.mscbsc.com,版权所有
先转化成文本格式，再粘贴到EXCEL表格！)#$@&%#*(我)K:JFD()$#_*(本文来自移动通信网www.mscbsc.com,版权所有
 sailuo说的太有才了！89西7K:JFD本文来自移动通信网www.mscbsc.com,版权所有
1fds3a21fd3sK:JFD()$#_*(本文来自移动通信网www.mscbsc.com,版权所有

说那么多还不如&实用，你只要记住&就是把两个单元格里的数字合并在一起就行了。#$@&%#K:JFD(本文来自移动通信网www.mscbsc.com,版权所有