You can search for a newline character in the Find & Replace dialogue box by searching for \n as a regular expression. You can use the text function CHAR(10) to insert a newline character into a text formula.
通过采用正则表达式进行搜索，\n可以在“查找和替换”对话框中搜索换行符。通过使用文本函数 CHAR(10)，可以将换行符插入到文本公式中。