Concatenate, preserve formatting

N

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
 
N

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.
 
Top