Tom’s Tutorials For Excel: Adding Text With a Custom Format
There are times when you want to append text to a cell’s existing text, without using a helper column with a concatenation formula, and without any programming methods.
As you know, formatting a cell only changes the visual appearance of the cell; the cell’s underlying actual value stays intact and unaffected. If the appended text is just for visual benefit as shown in the following pictured example, here is how you can utilize a custom format to get the job done. In the picture, the company wants “Widget Item” to appear in front of all its listed Product Items.
Select the range of interest and right-click the mouse. From the popup menu, select Format Cells.
In the Format Cells dialog box:
• Select the Number tab.
• In the Category pane select Custom.
• In the Type field, enter
"Widget Item "@
• Click OK.