how combine text and date display in word wrapped cell 2

[Jaffey]

I want to display "Posted on Mar 14" as a column label. The date portion is to be grabbed from another cell.
I also want the label to be word wrapped so it doesn't take up so much space.

I have tried using =Concatenate("Posted on ", A1) and it wraps fine but I can't the date to display in date format, it will only show "Posted on 39155" no matter how I try to configure the formatting.

I have also tried custom formatting the cell and inserted the test before the value but the results won't wrap. Any suggestions?

 

[Gavona]

You need the date to be formatted to display correctly. have a look at the Text function. I am not sure that I understand the value of the Concatenate function. This will work just as well:
="posted on "&TEXT(A1,"DD MMM YY")


Gavin

 

[macropod]

Hi Jaffey,

To force wrapping after ="posted on", you could code the formula as:
="posted on"&CHAR(10)&TEXT(A1,"DD MMM YY")

Cheers

[MS MVP - Word]