How to Locate the Line Break

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

=FIND(CHAR(10),Cell)

Explanations:

- CHAR(10): Line break;

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

Example:

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

How to locate the first
line
break

=FIND(CHAR(10),A1)

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