excel如何把多列数据合并且变成加符号的另一列数据

Question

如图，想把多列数据合并成一列，并且变成如红框内的数据，请excel大神帮忙，在线等，多谢

Answer 1

F2:=CONCATENATE((""""&TEXT(B2,"yyyy-m-d")&""""& ","),(""""&TEXT(C2,"hh:mm")&""""& ","),(""""&D2&""""& ","),(""""&E2&""""))

本回答被提问者采纳

Answer 2

写VBA代码可以实现你说的！
=B2&","&C2&","&D2&","&E2

Answer 3

=""""&TEXT(B2,"e-m-d")&""","""&TEXT(C2,"hh:mm")&""","""&D2&""","""&E2&""""

Answer 4

=CONCATENATE("""",B2,""",""",C2,""",""",D2,""",""",E2,"""")

Answer 5

无图无真像，无法帮你。