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\")
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\")
There are currently 4 users browsing this thread. (0 members and 4 guests)
Bookmarks