Concatenate, preserve formatting

[Nick]

Hi,

Does anyone know how I can concatenate some cells, one of
which includes a date, into a sentence that preserves the
formatting of the date?

Thanks in advance for any help.


Nick

 

[Norman Harker]

Hi Nick!

Use the following structure:

="Today is "&TEXT(TODAY(),"ddd dd-mmm-yyyy")

Just use the formatting string that you want as the second argument of
the TEXT function.