Malcolm has attended:
Excel Advanced course
Outlook Advanced course
Strings and labels
How do I link a month and year into a label
eg Year end ... 31 December 2008
RE: Strings and labels
Hi Malcolm
Thank you for your question and welcome to the forum.
Assuming you have something like the date in cell A1, the month in cell B1 and the year in cell C1, you can create a formula in another cell to join these together:
=A1&" "&B1&" "&C1
The " " is to enter a space between the date and month, and month and year respectively.
I hope this helps.
Amanda