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.
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) |
Last edited: