Excel function for concatenate

 =CONCATENATE("Insert into test values('",B1,"','",C1,"');")