Tip Printed from ExcelTip.com

---

Combining Text and Formatted Values


To combine text with a formatted value:

1. In cell A1, enter the text IBM owe Limelight Media Inc.
2. In cell A2, enter the number 4222.
3. In cell A3, enter the text for services supplied in March 2004.
4. In cell A5, enter the formula:
=A1&" "& TEXT(A2,"$ #,##0") &" "&A3

To format the number to present it in thousands:

Change the number format to "$ #, K":
=A1&" "& TEXT(A2,"$#, K") &" "&A3