Check the box that says “Show input message when cell is selected.” Add a title (32 characters). Type your input message (255 characters). Click OK.

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

When you need to format text in multiple ways in a single cell in Microsoft Excel, then this guide shows you how to do it the easy way.