字符串和单元格内容拼接函数CONCATENATE
a@马踏星空:
=CONCATENATE(D2,E2,F2)
拼接指定单元格内字符串,无分隔符
a@马踏星空:
=CONCATENATE(I4,"-",E4)
拼接指定单元格内字符串,指定分隔符-
a@马踏星空:
=CONCATENATE("Nginx","-",I4,"-",E4)
拼接指定单元格内字符串,指定分隔符-,再添加其它字符串
2024-02-29 19:58:34
a@马踏星空:
=CONCATENATE(D2,E2,F2)
拼接指定单元格内字符串,无分隔符
a@马踏星空:
=CONCATENATE(I4,"-",E4)
拼接指定单元格内字符串,指定分隔符-
a@马踏星空:
=CONCATENATE("Nginx","-",I4,"-",E4)
拼接指定单元格内字符串,指定分隔符-,再添加其它字符串