using xml import to get text in span code example

Example: IMPORTXML DIV TEXT

=JOIN(CHAR(10),IMPORTXML("http://www.w3.org/","//div[@class='event closed expand_block']//text()"))