How to Locate the Line Break

To locate the first line break in a text string, please use FIND function.



- CHAR(10): Line break;

– FIND(CHAR(10),Cell): Find the line break in the cell with a text string;


1. To find the first line break location in Cell A1, which has the following content:

How to locate the first


2. To locate the second line break:

=FIND(CHAR(10),A2, FIND(CHAR(10),A2)+1)

- CHAR(10): Line break

- FIND(CHAR(10),A1): Find the location of the first line break;

- FIND(CHAR(10),A1,FIND(CHAR(10),A1)+1): Find the location of line break from the letter after the first line break.

Leave a Reply