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.
