How to Add Text To A Sum In Excel – 2577

You have a sum in Excel. You want to add some text to the sum. Maybe something like “Please remit $” before the number. This video shows two methods. The first uses Concatenation. The second uses a custom number format, with different text showing for positive, negative, and zero. Also in this video: using F4 to repeat a command.

Common Search Terms answered by this video:
how to concatenate a number with text in Excel
how to add text to sum in Excel.
how to join text and a number in Excel.

Table of Contents
(0:00) Concatenate text with SUM
(0:26) Custom number format to add text before number
(1:40) Wrap-up