Excel Concatenate Date Cells With Text Cells

You must first convert the referenced date cells to text, otherwise you end up with an unexpected result.
B3=165
C3=6/14/2011
D3=TEXT(C3,"m/d/yy")&" "&B3

Result in cell D3 will be: 6/14/11 165

Popular Posts