» 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:
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Financial Modeling - 2nd Edition
- Special Edition Using Microsoft Word 2002
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Windows XP for Dummies
Combining Text and Formatted Numbers into a Single Entity
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.