Need help on CONCAT function for multiple column values

[Srikanth0990]

COL1	COL2	COL3	CONCAT RESULT
B972	02	DPP	('B972','02','DPP');

[#2]

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)

[#3]

@Jihad Al-Jarady It's not working as expected

[#4 · Accepted solution]

Do you want the result to be this: ('B972','02','DPP');
If yes, this the formula
=CONCAT("('",A1,"','",B1,"','",C1,"');")

[#5]

@Srikanth0990 

Depending on how precise you need the result to be, you might simply use:

=ARRAYTOTEXT(A2:C2,1)

[#6]

If I use Arraytotext getting like below
{"B972",2,"DPP"}

[#7]

@Srikanth0990 

As variant

="('" & TEXTJOIN("','", 1, A2:C2) & "')"

[#8]

It works, Thank you!

[#9]

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')

[#10]

@Srikanth0990 

Sorry, I didn't catch. Do you mean it shall be like

?

[#11]

I need to include this INSERT INTO TABLE VALUES in Result 1 columns

Result1 should be
INSERT INTO TABLE VALUES('B972','02','DDP')

[#12]

@Srikanth0990 

That could be

="INSERT INTO TABLE VALUES('" & TEXTJOIN("','", 1, A2:C2) & "')"

[#13]

Thanks a ton!!

[#14]

@Srikanth0990 

You are welcome