ExcelBanter - Concantenate columns with dates and text

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Concantenate columns with dates and text (https://www.excelbanter.com/excel-worksheet-functions/226657-concantenate-columns-dates-text.html)

Dazed and Confused[_2_]

Concantenate columns with dates and text

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

Concantenate columns with dates and text

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.

"Dazed and Confused" wrote:

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.

Dazed and Confused[_2_]

Concantenate columns with dates and text

Perfect! Thank you so very much!

"PJFry" wrote:

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.

"Dazed and Confused" wrote:

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.

All times are GMT +1. The time now is 08:38 AM.