concatenated dates

  • Thread starter Thread starter judith
  • Start date Start date
J

judith

Is it possible to concatenate a cell with a date and a
text cell and retain the date format.

e.g. a1 contains "Enclosed document dated:"
a2 contains 21 Nov 2003 Formatted d mmm yyyy

I want to set cell A10 to =A1 & A2
and display Enclosed document dated 21 Nov 2003

Thanks
 
One way:

You can't retain formatting, since worksheet functions can only
return values. However, you can format the date in the concatenated
cell:


=A1 & TEXT(A2,"d mmm yyyy")
 
Back
Top