Tip Printed from ExcelTip.com

---

Combining Text and Formatted Numbers into a Single Entity


Problem:

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