Adding a text to a cell in Excel using Formula requires use of ampersand operator, CONCAT function, or the LEFT, RIGHT, and LEN functions.

Click the "Insert" tab and then click the "Text Box" button in the ribbon's Text group. The cursor changes to a "T." Drag the Text Box Tool next to the Gantt chart to create a text box.

How to Insert a Combo Box in Excel 2010. Combo boxes are a useful way of entering data into an Excel spreadsheet, combining the flexibility of a text field with the convenience of a list box.