写一个EXCEL公式,将表格B行中B2到B8所有有内容的单元格用符号'+'连接起来,如果没有内容后面不要有+符号
时间: 2024-03-05 08:51:08 浏览: 21
可以使用以下公式将B2到B8中有内容的单元格用'+'符号连接起来:
```
=IF(B2<>"",B2,"")&IF(B3<>"","+ "&B3,"")&IF(B4<>"","+ "&B4,"")&IF(B5<>"","+ "&B5,"")&IF(B6<>"","+ "&B6,"")&IF(B7<>"","+ "&B7,"")&IF(B8<>"","+ "&B8,"")
```
这个公式会检查每个单元格是否有内容,如果有则用'+'符号连接起来,否则不添加符号。注意,这个公式不包括B1单元格。
相关问题
写一个EXCEL公式,将表格B行中B1到B8所有有内容的单元格用符号'+'连接起来,如果没有内容后面不要有+符号
可以使用以下公式将B1到B8中有内容的单元格用'+'符号连接起来:
```
=IF(B1<>"",B1,"")&IF(B2<>"","+ "&B2,"")&IF(B3<>"","+ "&B3,"")&IF(B4<>"","+ "&B4,"")&IF(B5<>"","+ "&B5,"")&IF(B6<>"","+ "&B6,"")&IF(B7<>"","+ "&B7,"")&IF(B8<>"","+ "&B8,"")
```
这个公式会检查每个单元格是否有内容,如果有则用'+'符号连接起来,否则不添加符号。
写一个EXCEL公式,将表格B行中B2到B20所有有内容的单元格用符号'+'连接起来,如果没有内容后面不要有+符号
可以使用以下公式将B2到B20中有内容的单元格用'+'符号连接起来:
```
=IF(B2<>"",B2,"")&IF(B3<>"","+ "&B3,"")&IF(B4<>"","+ "&B4,"")&IF(B5<>"","+ "&B5,"")&IF(B6<>"","+ "&B6,"")&IF(B7<>"","+ "&B7,"")&IF(B8<>"","+ "&B8,"")&IF(B9<>"","+ "&B9,"")&IF(B10<>"","+ "&B10,"")&IF(B11<>"","+ "&B11,"")&IF(B12<>"","+ "&B12,"")&IF(B13<>"","+ "&B13,"")&IF(B14<>"","+ "&B14,"")&IF(B15<>"","+ "&B15,"")&IF(B16<>"","+ "&B16,"")&IF(B17<>"","+ "&B17,"")&IF(B18<>"","+ "&B18,"")&IF(B19<>"","+ "&B19,"")&IF(B20<>"","+ "&B20,"")
```
这个公式会检查每个单元格是否有内容,如果有则用'+'符号连接起来,否则不添加符号。注意,这个公式包括B2到B20单元格,如果需要修改范围,只需更改公式中的B2和B20即可。