Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

How to Add Text To A Sum In Excel – 2577

Posted on by Annie D

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

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

MrExcel.comTue, March 28, 2023 8:45am