» 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:
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Now, Discover Your Strengths
- Marketing Management
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- Microsoft Windows XP Step by Step (With CD-ROM)
- Accounting and Financial Fundamentals for Nonfinancial Executives
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.