How do I combine text and formula in a single cell? For example "Year: 2015". So the "Year:" part would be text and the "2015" an automatic evaluation of the current year.
Thanks.
iMac (27-inch Late 2009), OS X Yosemite (10.10.3)
You could try this:
The formula in A2:
="Year: "& YEAR(TODAY())
SG
You could try this:
The formula in A2:
="Year: "& YEAR(TODAY())
SG
Thanks a lot, exactly what I needed!
Glad to hear that did the trick. Thanks for the green tick.
Just in in case you will be using this across multiple years, remember that the TODAY function is "live" in the sense that it updates every time you make a change to your document. So when you get to the end of the year you'll want to select the cells showing the "old" year, command-c to copy, and Edit > Paste Formula Results to "freeze" the values in those cells so they don't update to show the new year.
SG
How do I combine text and formula in a single cell?
