Concantenate columns with dates and text

[Dazed and Confused]

The first two columns in my spreadsheet are dates. The third is text. When
I try to concantenate, the dates turn into numbers.

Any advice would be greatly appreciated.
Thank you.

 

[PJFry]

Say that your dates are in A1 and B1 and your text is in C1.

=Text(A1,"mm/dd/yyyy")&Text(B1,"mm/dd/yyyy")&C1

Try that.

 

[Dazed and Confused]

Perfect! Thank you so very much!

Say that your dates are in A1 and B1 and your text is in C1.

=Text(A1,"mm/dd/yyyy")&Text(B1,"mm/dd/yyyy")&C1

Try that.
--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.