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

How to add helpful prompts to Microsoft Excel cells Enhance your spreadsheets by providing on-the-spot instructions.