Concatenate with dates

[kmc]

Hello,
I am combining two columns, one has text, the other a date. However, the date is not showing in the same format as the original column.

Date in formula bar reads as "2/6/2014 9:47:56 AM"

See below and please advise.

Excel 2012
	A	D	E	F
1	date	Party_Name	Comment	name date
2	2/6/2014	last,first	LOGIN_FAILURE	last,first - 41676.408287037
login report

Cell Formulas
Range	Formula
F2	=CONCATENATE(D2," - ",A2)

 

[bbott]

Try this:

=D2&" - "&TEXT(A2,"mm/dd/yyyy")

 

[Rick Rothstein]

Hello,
I am combining two columns, one has text, the other a date. However, the date is not showing in the same format as the original column. See below and please advise.

Excel 2012

	A	D	E	F
1	date	Party_Name	Comment	name date
2	2/6/2014	last,first	LOGIN_FAILURE	last,first - 41676.408287037

<colgroup><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

login report​

Worksheet Formulas Cell Formula F2 =CONCATENATE(D2," - ",A2) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Try it this way...

=CONCATENATE(D2," - ",TEXT(A2,"d/m/yyyy"))

Note: Could not tell if your date order was d/m/yyyy or m/d/yyyy so I guessed at the former (change it if wrong).

 

[kmc]

both options worked perfectly. Thanks!