How to insert line break in excel

We can Insert line break between two words (apple-orange) with CHAR function.

you can use CHAR(10) to add a line break. Text wrap must be enabled to see the line break take effect.

=CHAR(10)----->>>>answer is  linebreak

CHAR function

The CHAR function is one of the TEXT functions of Excel.

It Returns the character specified by the code number from the character set for your computer.

CHAR arguments

CHAR function has 1 argument:

1. Number section is a number between 1 and 255 specifying which character you want.

Related posts:

Excel TYPE Function Keyboard Shortcut to cut a cell value Excel TEXTJOIN Function Excel FORMULATEXT Function