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"}