更新时间:2023-11-07 14:30:28
使用TEXTJOIN
函数.给出一个空的定界符,TRUE
表示忽略为空,引用的单元格为text1,并且不为text2提供任何内容.
Use the TEXTJOIN
function. Give an empty delimiter, TRUE
for the ignore empty, the referenced cell as text1, and don't supply anything for text2.
=TEXTJOIN("",TRUE,A1)
完成.