The FILTERXML function is a powerful function in Excel that allows you to extract data from a string using XPath-like syntax. To split cells by line break using FILTERXML, use the following formula: =FILTERXML(""&SUBSTITUTE(A1,CHAR(10),"")&"","//s"). Replace A1 with the reference to your original cell containing the line breaks. Note that the FILTERXML function is available in Excel 2013 and later versions.