excel表格里单元格数值转型公式
发布网友
发布时间：2022-04-23 06:39
共5个回答
热心网友
时间：2023-07-05 17:42
（公式已经做了去掉多余逗号的处理）在V15输入
=H15&IF(I15<>"",","&I15,"")&IF(J15<>"",","&J15,"")&IF(K15<>"",","&K15,"")&IF(L15<>"",","&L15,"")&IF(M15<>"",","&M15,"")&IF(N15<>"",","&N15,"")&IF(O15<>"",","&O15,"")&IF(P15<>"",","&P15,"")&IF(Q15<>"",","&Q15,"")&IF(R15<>"",","&R15,"")&IF(S15<>"",","&S15,"")&IF(T15<>"",","&T15,"")&IF(U15<>"","/"&U15,"")
下拉
热心网友
时间：2023-07-05 17:42
很简单的：
点V15——在编辑栏输入=(H15:T15)——按F9（先不要回车！！！）——再删除“={”和“}”并输入/2
其他参照操作，很快了哦。
当然用合并公式“&”或“CONCATENATE”也行，但你就要输入到头晕了吧？
热心网友
时间：2023-07-05 17:43
=SUBSTITUTE(SUBSTITUTE(H15&","&I15&","&J15&","&K15&","&L15&","&M15&","&N15&","&O15&","&P15&","&Q15&","&R15&","&S15&","&T15&"/"&U15,",,",""),",/","/")
热心网友
时间：2023-07-05 17:43
算，需手动的。
点菜单 工具--->选项---->重新计算 在计算项中选择自动重算单选项即可.
热心网友
时间：2023-07-05 17:44
用CONCATENATE函数，=CONCATENATE(A1,",",B1,.........,"/",U1) 这样
