Tip Printed from ExcelTip.com

---

Combining Text and a Formatted Date into a Single Entity


Problem:

Combining the text in cell A2 with the date in cell B2 to form a single text value in cell C2.

Solution:

Use the TEXT function as shown in the following formula:
=A2&" "&TEXT(B2,"mm/dd/yyyy")