Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/01/Start-new-line-in-excel-cell.xlsx

In this video I demonstrate how to type multiple lines in a single cell. You have probably discovered that if you press ENTER in a cell, Excel takes you out of the cell instead of letting you create a new line. There are two ways around this problem - the first with a shortcut key and the second with formula.

The functions featured in this video are CHAR(), TEXTJOIN(), CONCATENATE() and SUBSTITUTE().

This video answers the following queries:
How to Start a new line of text inside a cell in Excel
How to create a line break in Excel
How to write a line break formula in Excel
How to put multiple lines in Excel cell
How to create a new line in Excel cell formula
How to create multiple rows in one cell in Excel
------------------------