exal转sql语句 CONCATENATE

Exal函数：

=CONCATENATE("

INSERT INTO dbo.Doctor_Temp(Code,Name,HospitalCode,HospitalName,Department,Position,Level,Status,IsActive)
VALUES('",A82,"','",B82,"','",C82,"','",D82,"','",E82,"','",G82,"','",H82,"','",J82,"','",I82,"')
")

 

位置：必须要放在箭头位置

 

结果：

得到文本：