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,"');")
13 Replies
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"}
Hi Srikanth0990
This is the formula for using concat is this, Concat(col1,col2,col3), and
=CONCAT(A2,B2,C2)
if you want to add space between values:
=CONCAT(A2," ",B2," ",C2)
Jihad Al-Jarady It's not working as expected
- Do you want the result to be this: ('B972','02','DPP');
If yes, this the formula
=CONCAT("('",A1,"','",B1,"','",C1,"');")
