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.

Click an Excel worksheet cell that you've linked to a drop-down list. For example, if cell E1 displays a drop-down list when you click it, click that cell to select it.

Combining text from multiple cells into one cell in Excel is very useful for users like users who want to create a mailing list, prepare data for import, etc.