|  

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


Rate This Tip
12 34 5
Rating: 4.50     Views: 12479
No comments have been submitted.
Name
Comment Title
Comments