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
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 function has 1 argument:
- Number section is a number between 1 and 255 specifying which character you want.