ExcelBanter - Concatenate

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Concatenate (https://www.excelbanter.com/excel-worksheet-functions/188793-concatenate.html)

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 ?

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Sheriff" wrote:
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 ?