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.

Concantenate columns with dates and text
 

Use the TEXT function to format the date as you wish it to appear, eg:
=TEXT(A1,"Mmm d, yyyy") & B1

"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.

Concantenate columns with dates and text
 

Thank you!

"bapeltzer" wrote:

Use the TEXT function to format the date as you wish it to appear, eg:
=TEXT(A1,"Mmm d, yyyy") & B1

"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.