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,"');")
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,"');")