Concatenating date with a string in Excel

user_117700 0
Viewed 113470

I have two cells in Excel. one has a string and the other one has a date. in the third cell I want to put the date and the string together. For example:

A1 = "This "
A2 = "03/03/1982"

I want A3 to be:

This 03/03/1982

when I try to put this in the A3 formula: = A1 & A2 it returns some funny numerical value for the date and does not give me the literal date.

worksheet-function excel
6 Answers

I found that for this situation, the simplest solution is to define a Custom number format for the cell containing the date. The format in this case should be:

"This:" mm/dd/yyyy

To set this format:

  1. Right click on the cell
  2. Select Format Cell
  3. Select Number tab (should be displayed by default)
  4. Pick Custom from the Category list
  5. Specify the format in the "Type" field
  6. Press OK

Note: If you really want the preceding text to be picked from a cell, this solution will not work as described.

user_39588430
Related