Concatenating date with a string in Excel

The Solution to Concatenating date with a string in Excel is


Don't know if it's the best way but I'd do this:

=A1 & TEXT(A2,"mm/dd/yyyy")

That should format your date into your desired string.

Edit: That funny number you saw is the number of days between December 31st 1899 and your date. That's how Excel stores dates.

~ Answered on 2011-06-13 21:26:10


Most Viewed Questions: