» Combining Text and a Formatted Date

CATEGORY - Excel Editing VERSION - All Microsoft Excel Versions

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