Concatenate

[Sheriff]

Simple Question ( I think ). I have a cell set up with the formula "=TODAY()"
in it. I have formatted this cell to look like just the month (i.e. May /
mmmm ) . I then have a series of Concatenate formulaes set up which connects
to tha cell, for example =concatenate("text", C5, "text"), with the cell C5
being the month. Unfortunately the month appears as a serial number not as
the month (i.e May). How could I go about changing this ?

 

[Max]

You could use something like this to get the concat string:
="text1 "&TEXT(C5,"mmmm")&" text2"
where C5 contains: = TODAY()

The "&" operator is a shorter way to concat

Adapt to suit