» Combining Text and a Formatted Date into a Single Entity
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
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")
Book Store:
Recommended Books:
- Investments + S&P Card + Powerweb + StockTrak discount coupon
- Windows XP for Dummies
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Accounting Principles, with CD, 6th Edition
- Special Edition Using Microsoft Excel 2002
No comments have been submitted.
