使用Excel生成SQL语句--CONCATENATE函数

使用Excel生成SQL语句：

希望得到的sql语句

replace into goods(iid,tbk_url,title) values(17657031670,'%2BPkqB07S4%2FK0CFcRfH0GoT805sipKkM4JJinymmJfIXHf3aAoBrDlXdmxixM797FS8aFZ1yRafZAJjpy%2BWed9nFhf9y7AniperG%2BaE%3D','');

Excel公式：在 D2中输入下面公式即可

=CONCATENATE("replace into goods(iid,tbk_url,title) values(",A2,",","'",B2,"'",",","'",C2,"'",");")

Excel表头：
A                                           B                                                                          C                         D

iid

tbk_url

title