如何连接excel中的日期列与保持原始日期不变的另一列？(How to concatenate date column in excel with another column keeping ori

如何连接excel中的日期列与保持原始日期不变的另一列？(How to concatenate date column in excel with another column keeping original date intact?)

我在Excel中有两列：

InsertDate，FeedbackId

我想通过用逗号分隔它们来连接这两列。 我写了这个公式： - = concatenate（B212，“---”，C212）但问题是它将日期转换为一些整数ie

InsertDate = 2017年6月5日和FeedbackId = 1，

输出结果是“42891,1”，我想成为“05-Jun-2017,1”

I have 2 columns in excel:

InsertDate, FeedbackId

I want to concatenate these two columns by separating them with a comma. I have written this formula:-=concatenate(B212,"---", C212) but the problem is it is converting the date to some integer i.e.

InsertDate=05-Jun-2017 and FeedbackId=1,

The output is "42891,1" which I want to be "05-Jun-2017,1"

最满意答案

尝试下面的使用TEXT转换为串联字符串

=CONCATENATE(TEXT(InsertDate,"dd-mmm-yyyy"),",",FeedbackID)

try the following use TEXT to convert to a string for concatenation

=CONCATENATE(TEXT(InsertDate,"dd-mmm-yyyy"),",",FeedbackID)