How to insert line break in excel

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

How to insert line break in excel

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.

Leave a Reply

Your email address will not be published. Required fields are marked *