Example: Format a number without decimal places, with a thousands separator, and combine it with text.
- In cell A1, enter the text "You still owe the sum of".
- In cell A2, enter the number - 5434.
- In cell A3, enter the text "for invoice # 2232 from 6/15/2001".
- In cell A4, enter the formula =A1&""&TEXT(A2,"#,##0")&""&A3.
Formatting a number with the thousands sign - the letter K
The formula =A1&" "&TEXT(A2,"#,K")&" "&A3
The sentence appearing in the cell - "You still owe the sum of 5K for invoice # 2232 from 6/15/2001".
Screenshot // Format number in joining text with linked number in Microsoft Excel