Strings and labels

Resolved · Low Priority · Version 2003

Wed 17 Dec 2008, 16:37 Delegate Malcolm said...

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

Wed 7 Jan 2009, 14:44 Trainer Amanda said...

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

Wed 14 Jan 2009: Automatically marked as resolved.

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips

Strings and labels

Strings and labels

RE: Strings and labels

Excel articles

Excel tip:

Sorting List Subtotals