EXCEL多个单元格的文字合并,并用符号分隔

发布网友发布时间：2022-04-27 07:47

共5个回答

热心网友时间：2023-09-14 00:22

公式如下：

=A1&IF(B1="","","、B1")&IF(C1="","","、C1")&IF(D1="","","、D1")&IF(E1="","","、E1")

效果如图所示：

热心网友时间：2023-09-14 00:22

这公式不难,但是很恶心我只给你写了B2到B10,剩下的你自己照着写吧.太长了.
公式如下:
=IF(B2<>"",B2,"")&IF(B3<>"",IF(B2="",B3,"、"&B3),"")&IF(B4<>"",IF(COUNTBLANK(B2:B3)=2,B4,"、"&B4),"")&IF(B5<>"",IF(COUNTBLANK(B2:B4)=3,B5,"、"&B5),"")&IF(B6<>"",IF(COUNTBLANK(B2:B5)=4,B6,"、"&B6),"")&IF(B7<>"",IF(COUNTBLANK(B2:B6)=5,B7,"、"&B7),"")&IF(B8<>"",IF(COUNTBLANK(B2:B7)=6,B8,"、"&B8),"")&IF(B9<>"",IF(COUNTBLANK(B2:B8)=7,B9,"、"&B9),"")&IF(B10<>"",IF(COUNTBLANK(B2:B9)=8,B10,"、"&B10),"")

热心网友时间：2023-09-14 00:23

B2&"、"&B3&"、"&B4&"、"&B5&"、"&B6
改成:
if(B2="","",B2)&"、"&if(B3="","",B3)&"、"&if(B4="","",B4)&"、"&if(B5="","",B5)&"、"&if(B6="","",B6)即可

热心网友时间：2023-09-14 00:23

手头没有excel,如果你的产品里面没有顿号，用replace函数替代连续两个顿号，再判断首尾是否有顿号再处理一下应该可以

热心网友时间：2023-09-14 00:24

3,4,5,6,7,8,9},A1&"0123456789")),4^8)