Japanese version. Here we show how to get the position of a newline in a cell with the FIND function. Steps. To represent a newline in a cell as a string, use the CHAR function and set it to CHAR(10). This and the LEFT, RIGHT, and LEN functions can also be used to obtain the before and after line breaks. Links Tips. Others.(Microsoft Excel)