» 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:
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- East of Eden (Oprah's Book Club)
- Retire Young, Retire Rich
- Analysis of Financial Statements
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
No comments have been submitted.
