使用特殊字符在Excel中连接(Concatenate in excel with special characters)

使用特殊字符在Excel中连接(Concatenate in excel with special characters)

这是我的excel表

state City Name area type GUJARAT Abdasa City GUJARAT Adalaj City GUJARAT Ahwa City

我想创建它（当然在区域类型旁边的行中）

('GUJARAT','Abdasa','City'),

为此，我尝试了以下公式

=CONCATENATE("('"+A2+"','"+B2+"','"+C2+"'),") =CONCATENATE("('" & A2 & "','" & B2 & "','" & C2 & "'),")

我不太了解Excel这可能吗？

This is my excel table

state City Name area type GUJARAT Abdasa City GUJARAT Adalaj City GUJARAT Ahwa City

I want to create this(in the row next to area type of course)

('GUJARAT','Abdasa','City'),

For that I have tried following formulas

=CONCATENATE("('"+A2+"','"+B2+"','"+C2+"'),") =CONCATENATE("('" & A2 & "','" & B2 & "','" & C2 & "'),")

I don't know much about Excel is this possible?

最满意答案

您不需要同时使用CONCATENATE()和&运算符 - 它们也可以执行相同的操作。

如果你使用& ，写：

="('" & A2 & "','" & B2 & "','" & C2 & "'),"

如果CONCATENATE() ，写：

=CONCATENATE("('",A2,"','",B2,"','",C2,"'),")

You don't need to use both CONCATENATE() and & operator - they do the same thing.

If you use &, write:

="('" & A2 & "','" & B2 & "','" & C2 & "'),"

If CONCATENATE(), write:

=CONCATENATE("('",A2,"','",B2,"','",C2,"'),")