» Combining Text and a Formatted Date into a Single Entity
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
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")
Book Store:
Recommended Books:
- Keys to Reading an Annual Report (Barron's Business Keys)
- Fish! A Remarkable Way to Boost Morale and Improve Results
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Accounting Principles, with CD, 6th Edition
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- Retire Young, Retire Rich
No comments have been submitted.
