Forum Discussion
Solved
Need help on CONCAT function for multiple column values
COL1 COL2 COL3 CONCAT RESULT B972 02 DPP ('B972','02','DPP');
- Do you want the result to be this: ('B972','02','DPP');
If yes, this the formula
=CONCAT("('",A1,"','",B1,"','",C1,"');")
Depending on how precise you need the result to be, you might simply use:
=ARRAYTOTEXT(A2:C2,1)
If I use Arraytotext getting like below
{"B972",2,"DPP"}
{"B972",2,"DPP"}
- How it works if I include COL3
COL1 COL2 COL3 COL4 Result
B972 02 DPP INSERT INTO TABLE VALUES INSERT INTO TABLE VALUES('B972','02','DDP')
B9FD 02 DPP INSERT INTO TABLE VALUES INSERT INTO TABLE VALUES('B9FD','02','DDP')
B976 AB DPP INSERT INTO TABLE VALUES INSERT INTO TABLE VALUES('B976','AB','DDP') - It works, Thank you!
