|  

» Combining Text and a Formatted Date

To combined text with a formatted date:

1. In cell A1, enter the text The book publication month is.
2. In cell A2, enter the date 02/01/2004.
3. In cell A3, enter the formula:
=A1&" "& TEXT(A2,"mmmm yyyy")
Screenshot // Combining Text and a Formatted Date
Combining Text and a Formatted Date


Rate This Tip
12 34 5
Rating: 3.41     Views: 22857
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments