In the example above, I have a value of 347 in the C12 range. I would like to add “Units Sold” after the value. First I right click then click format cells. In the custom area, I type
0 “Units Sold”. The zero represents the value of the formula and anything I want after it needs to be in quotes.
The output looks like the screenshot as shown below.