实现方式
使用excel字符串函数,拼接字符串,用$B2占位符替换真实内容,下拉单元格
=TEXTJOIN(" ",TRUE,"udpate table1 set name=",$B2,",age=",$C2," where id=",A2 )
=CONCAT("udpate table1 set name=",$B2,",age=",$C2," where id=",A2 )
示例如下
使用excel字符串函数,拼接字符串,用$B2占位符替换真实内容,下拉单元格
=TEXTJOIN(" ",TRUE,"udpate table1 set name=",$B2,",age=",$C2," where id=",A2 )
=CONCAT("udpate table1 set name=",$B2,",age=",$C2," where id=",A2 )
示例如下