» Combining Text and Formatted Numbers into a Single Entity
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Combining the data from cells A2:C2 into a single cell and ensuring that the number in B2 is formatted as currency.
Solution:
Use the TEXT function as shown in the following formula:
=A2&" "&TEXT(B2,"$#,##0")&" "&C2
To display the dollar amount in thousands, modify the second argument in the TEXT function as follows:
=A2&" "&TEXT(B2,"$ #, K")&" "&C2
Book Store:
Recommended Books:
- Special Edition Using Microsoft Office XP
- Monte Carlo Methods in Finance
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- The Basics of Finance: Financial Tools for Non Financial Managers
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
Text Combining Formula
anusha
How do I copy this formula down? =B12&" "&C12
When I select and drag it it changes the cell refernce but the contents are the same in every cell?
Thanks for your help.
Text Combining Formula
anusha
How do I copy this formula down? =B12&" "&C12
When I select and drag it it changes the cell refernce but the contents are the same in every cell?
Thanks for your help.


When I select and drag it it changes the cell refernce but the contents are the same in every cell?
Thanks for your help.