使用特殊字符在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 CityI 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,"'),")更多推荐
发布评论