Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
strings and labels

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Strings and labels

Strings and labels

ResolvedVersion 2003

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

Wed 14 Jan 2009: Automatically marked as resolved.

Excel tip:

Using an equal (=) sign that isn't part of a formula

Before you type the equal sign, type an apostrophe: '
Then type your equal sign: = (and anything else you want to add after your equal sign)
Press ENTER.

(the apostraphe will disappear

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.