Google Spreadsheets: importxml, multiple rows and columns

0

I'm trying to extract the names of federal deputies on the Chamber's website with importxml , eg:

=IMPORTXML("http://www.camara.leg.br/Internet/deputado/Dep_Detalhe.asp?id=5310518#";"/html/body/div[2]/div/div/div/div/div/div/div[1]/ul/li[1]")

The formula returns

<li><strong>Nome civil:</strong> JOSÉ GERALDO TORRES DA SILVA</li>

In two columns, but I only need the name after ":"

I tried ext.texto but it did not work.

    
asked by anonymous 05.04.2018 / 08:44

0 answers