Tip Printed from ExcelTip.com

---

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")